Comparison of relational database management systems: Difference between revisions

Revision as of 10:14, 19 March 2022

Revision as of 20:37, 20 March 2022

Line 116:

| {{No}}

|-

! [[IBM Db2 Family|Db2]]

| [[IBM]]

| 1983

Line 704:

| {{no}}

|-

! [[IBM DB2|DB2Db2]]

| {{yes}}

| {{yes}} ([[IBM DB2 Express-C|Express C]])

Line 1,372:

| {{Yes}}

|-

! [[IBM DB2|DB2Db2]]

| {{yes}}

| {{yes}}

Line 1,870:

| 254

|-

! style="text-align:left" | [[IBM DB2|DB2Db2]]

| Unlimited

| 2 [[zettabyte|ZB]]

Line 2,410:

| {{no}}

|-

! style="text-align:left" | [[IBM DB2|DB2Db2]]

| {{yes}}

| {{yes}}

Line 2,711:

| {{no}}

|-

! style="text-align:left" | [[IBM DB2|DB2Db2]]

| {{Yes}}

| {{Yes}}

Line 2,724:

| publisher = IBM

| series = Developer Works

| title = Full-text search with DB2Db2 Text Search

}}</ref>

| {{dunno}}

Line 3,550:

|-

! style="text-align:left" | [[IBM DB2|DB2Db2]]

| {{yes}}

| {{yes}}

Line 4,227:

| MONETARY, BIT VARYING, SET, MULTISET, SEQUENCE, ENUM

|-

! style="text-align:left" | [[IBM Db2|DB2]]

| {{dunno}}

| SMALLINT (16-bit), INTEGER (32-bit), BIGINT (64-bit)

Line 4,785:

| {{yes}}

|-

! style="text-align:left" | [[IBM DB2|DB2Db2]]

| {{yes}} via CHECK CONSTRAINT

| {{yes}}

Line 5,150:

| {{dunno}}

|-

! style="text-align:left" | [[IBM DB2Db2]]

| {{yes}}

| {{yes}}

Line 5,500:

| {{dunno}}

|-

! style="text-align:left" | [[IBM DB2|DB2Db2]]

| {{yes}}

| {{dunno}}

Line 6,006:

==External links==

{{wikibooks|SQL dialects reference}}

* [http://troels.arvin.dk/db/rdbms/ Comparison of different SQL implementations against SQL standards]. Includes Oracle, DB2Db2, Microsoft SQL Server, MySQL and PostgreSQL. <small>(8 June 2007)</small>

* [https://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt The SQL92 standard]

* [https://www.sql-workbench.eu/dbms_comparison.html DMBS comparison by SQL Workbench]