View source for Comparison of relational database management systems

The following tables compare general and technical information for a number of [[relational database management system]]s. Please see the individual products' articles for further information. Unless otherwise specified in footnotes, comparisons are based on the stable versions without any add-ons, extensions or external programs.

==General information==
{| style="text-align: center;" class="wikitable sortable"
|-
! style="width:16em" |
! Maintainer
! First public release date
! Latest stable version
! Latest release date
! License
|-
! style="text-align:left" | [[4th Dimension (Software)|4D (4th Dimension)]]
| 4D S.A.S.<ref>{{Citation | url = http://www.4D.com | title = 4D}}</ref>
| 1984
| v14.2
| 2014-07-10
| {{Proprietary}}
|-
! style="text-align:left" | [[ADABAS]]
| [[Software AG]]
| 1970
| 8.1
|2013-06
| {{Proprietary}}
|-
! style="text-align:left" | [[Adaptive Server Enterprise]]
| [[Sybase]]
| 1987
| 16.0
|
| {{Proprietary}}
|-
! style="text-align:left" | [[Advantage Database Server (ADS)]]
| [[Sybase]]
| 1992
| 11.1
| 2012
| {{Proprietary}}
|-
! style="text-align:left" | [[Altibase]]
| Altibase Corp.
| 2000
| 6.1.3
| 2014-04-18
| {{Proprietary}}
|-
! style="text-align:left" | [[Apache Derby]]
| [[Apache Software Foundation|Apache]]
| 2004
| 10.10.2.0<ref>{{cite web 
                  | title = Apache Derby: Downloads
                  | url = http://db.apache.org/derby/derby_downloads.html
                  | accessdate = 2014-07-06 }}</ref>
|  2014-04-15 
| {{free|[[Apache license|Apache License]]}}
|-
! style="text-align:left" | [[Clustrix]]
| [[Clustrix]]
| 2010
| v5.2
| 2013-10-16
| {{Proprietary}}
|-
! style="text-align:left" | [[CUBRID]]
| NHN Corporation<ref>{{Citation | url = http://www.nhncorp.com | title = NHN Corp.}}</ref>
| 2008-11
| 9.2.0
| 2013-10-24
| {{free|[[GNU General Public License|GPL]] v2 or later}}
|-
! style="text-align:left" | [[CA Datacom|Datacom]]
| [[CA, Inc.]]
| Early 70s<ref>{{cite journal
 | last = Stevens
 | first = O.
 | title = The History of Datacom/DB
 | journal = Annals of the History of Computing
 | volume = 31
 | issue = 4
 | pages = 87–91
 | publisher = IEEE
 | date = Oct–Dec 2009
 | url = http://ieeexplore.ieee.org/xpl/articleDetails.jsp?reload=true&arnumber=5370783
 | doi = 10.1109/MAHC.2009.108
 | issn = 1058-6180
 | accessdate = 2014-07-06}}</ref>
| 14<ref>{{cite web | title = CA Datacom - CA Technologies | url = http://www.ca.com/us/opscenter/ca-datacom.aspx }}</ref>
| 2012<ref>{{cite web | title = Datacom Product Sheet | url  = http://www.ca.com/us/~/media/Files/ProductBriefs/cs2277-ca-datacom-v14-ps.pdf }}</ref>
| {{Proprietary}}
|-
! style="text-align:left" | [[IBM DB2|DB2]]
| [[IBM]]
| 1983
| 10.5
| 2013-04-23
| {{Proprietary}}
|-
! style="text-align:left" | [[Drizzle (database server)|Drizzle]]
| [[Brian Aker]]
| 2008
| 7.1.36
|2012-05-23
| {{free|[[GNU General Public License|GPL]] v2 and v3, with some [[BSD License|BSD]] components}}
|-
! style="text-align:left" | [[Empress database|Empress Embedded Database]]
| Empress Software Inc<ref>{{Citation | url = http://www.empress.com/ | title = Empress}}</ref>
| 1979
| 10.20
| 2010-03
| {{Proprietary}}
|-
! style="text-align:left" | [[EXASolution]]
| [[EXASOL|EXASOL AG]]
| 2004<ref>{{Citation | url = http://www.exasol.com/ | title = EXASolution}}</ref>
| 4.2.8
| 2014-04-22
| {{Proprietary}}
|-
! style="text-align:left" | [[Firebird (database server)|Firebird]]
| Firebird project<ref>{{Citation | url = http://www.firebirdsql.org/ | title = Firebird SQL}}</ref>
| 2000-07-25
| 2.5.2
| 2013-03-24
| {{free|IPL<ref>{{Citation | url = http://www.firebirdsql.org/index.php?op=doc&id=ipl | title = IPL | publisher = Firebird SQL}}</ref> and IDPL<ref>{{Citation | url = http://www.firebirdsql.org/index.php?op=doc&id=idpl | title = IDPL | publisher = Firebird SQL}}</ref>}}
|-
! style="text-align:left" | [[HSQLDB]]
| HSQL Development Group
| 2001
| 2.3.1<ref>[http://sourceforge.net/projects/hsqldb/files/hsqldb/hsqldb_2_3/]</ref>
| 2013-10-08
| {{free|[[BSD license|BSD]]}}
|-
! style="text-align:left" | [[H2 (DBMS)|H2]]
| H2 Software
| 2005
| 1.3.171
| 2013-03-17
| {{free|[[Eclipse Public License|EPL]] and modified [[Mozilla Public License|MPL]]}}
|-
! style="text-align:left" | [[Informix Dynamic Server]]
| [[IBM]]
| <span style="display:none">1981????</span>1980
| 12.10.xC3
| 2014-03-14
| {{Proprietary}}
|-
! style="text-align:left" | [[Ingres (database)|Ingres]]
| [[Ingres (database)|Ingres Corp.]]
| 1974
| Ingres Database 10
| 2010-10-12
| {{partial|[[GNU General Public License|GPL]] and [[Proprietary software|Proprietary]]}}
|-
! style="text-align:left" | [[InterBase]]
| [[InterBase|Embarcadero]]
| 1984
| InterBase XE
| 2010-09-21
| {{Proprietary}}
|-
! style="text-align:left" | [[Linter SQL RDBMS]]
| [[RELEX Group]]
| 1990
| 6.x
| 2013-08-26
| {{Proprietary}}
|-
! style="text-align:left" | [[LucidDB]]
| The Eigenbase Project<ref>{{Citation | url = http://www.eigenbase.org/ | title = Eigenbase}}</ref>
| 2007-01
| 0.9.3
|
| {{free|[[GNU General Public License|GPL]] v2}}
|-
! style="text-align:left" | [[MariaDB]]
| [[MariaDB|MariaDB Community]]
| 2010-02-01
| 10.0.14<ref>[https://blog.mariadb.org/mariadb-10-0-14-now-available/], MariaDB 10.0.14 now available</ref>
| 2014-09-26
| {{free|[[GNU General Public License|GPL]] v2 and [[GNU Lesser General Public License|LGPL]] for client-libraries}}
|-
! style="text-align:left" | [[MaxDB]]
| [[SAP AG]]
| 2003-05
| 7.9.0.8
| 2014
| {{Proprietary}}
|-
! style="text-align:left" | [[Microsoft Access]] (JET)
| [[Microsoft]]
| 1992
| 15 (2013)
| 2012-10-02
| {{Proprietary}}
|-
! style="text-align:left" | [[Microsoft Visual Foxpro]]
| [[Microsoft]]
| 1984<ref name="en.wikipedia.org">{{Citation | url = http://en.wikipedia.org/wiki/Visual_FoxPro | title = VisualFoxPro}}</ref>
| 9 (2005)
| 2007-10-11<ref name="en.wikipedia.org"/>
| {{Proprietary}}
|-
! style="text-align:left" | [[Microsoft SQL Server]]
| [[Microsoft]]
| 1989
| 2014 (12)
|2014-03-18
| {{Proprietary}}
|-
! style="text-align:left" | [[SQL Server Compact|Microsoft SQL Server Compact (Embedded Database)]]
| [[Microsoft]]
| 2000
| 2011 (v4.0)
|
| {{Proprietary}}
|-
! style="text-align:left" | [[MonetDB]]
| The MonetDB Developer Team
| 2004
| 11.17.13
| 2014-03
| {{free|MonetDB License v1.1 (based on the [[Mozilla Public License|MPL]] 1.1)<ref>{{Citation | url = http://www.monetdb.org/Legal/MonetDBLicense | publisher = CWI | title = MonetDB Public License | number = 1.1}}</ref>}}
|-
! style="text-align:left" | [[mSQL]]
| Hughes Technologies
| 1994
| 3.9<ref>{{Citation | url = http://www.hughes.com.au/products/msql/ | publisher = Hughes | location = AU | series = Products | title = mSQL}}</ref>
| 2011-02
| {{Proprietary}}
|-
! style="text-align:left" | [[MySQL]]
| [[Oracle Corporation]]
| 1995-11
| 5.6.21
| 2014-09-23
| {{partial|[[GNU General Public License|GPL]] v2 or [[Proprietary software|Proprietary]]}}
|-
! style="text-align:left" | [[MemSQL]]
| [[MemSQL]]
| 2012-06
| 1.8 (2012)
| 2012-12
| {{Proprietary}}
|-
! style="text-align:left" | [[Nexusdb]]
| Nexus Database Systems Pty Ltd<ref>{{Citation | url = http://www.nexusdb.com/ | title = Nexus DB}}</ref>
| 2003-09
| 3.04
| 2010-05-08
| {{Proprietary}}
|-
! style="text-align:left" | [[Nonstop sql|HP NonStop SQL]]
| [[Hewlett-Packard]]
| 1987
| SQL/MX 2.3
|
| {{Proprietary}}
|-
! style="text-align:left" | [[Omnis|Omnis Studio]]
| TigerLogic Inc<ref>{{Citation | url = http://www.omnis.net/ | title = Omnis}}</ref>
| 1982-07
| 4.3.1 Release 1no
| 2008-05
| {{Proprietary}}
|-
! style="text-align:left" | [[OpenBase|OpenBase SQL]]
| OpenBase International<ref>{{Citation | url = http://www.openbase.com/ | title = OpenBase}}</ref>
| 1991
| 11.0.0
|
| {{Proprietary}}
|-
! style="text-align:left" | [[OpenEdge Database|OpenEdge]]
| [[Progress Software Corporation]]
| 1984
| 11.0
|
| {{Proprietary}}
|-
! style="text-align:left" | [[Virtuoso Universal Server|OpenLink Virtuoso]]
| OpenLink Software<ref>{{Citation | url = http://www.openlinksw.com/ | title = OpenLink Software}}</ref>
| 1998
|  7.x
| 2013-08-05
| {{partial|[[GNU General Public License|GPL]] v2 or [[Proprietary software|Proprietary]]}}
|-
! style="text-align:left" | [[Oracle Database|Oracle]]
| [[Oracle Corporation]]
| 1979-11
| 12c Release 1
| 2013-06-25
| {{Proprietary}}
|-
! style="text-align:left" | [[Oracle Rdb]]
| [[Oracle Corporation]]
| 1984
| 7.3.1.1.1
|2014-02-24<ref>{{Citation | url = http://www.oracle.com/technetwork/database/rdb/learnmore/rdb-pmatrix-rdb-086351.html | publisher = Oracle Corporation | title = Oracle Rdb Product Family Compatibility Matrix}}</ref>
| {{Proprietary}}
|-
! style="text-align:left" | [[Paradox (database)|Paradox]]
| Corel Corporation<ref>{{Citation | url = http://www.corel.com/ | title = Corel}}</ref>
| 1985
| 11
| 2003
| {{Proprietary}}
|-
! style="text-align:left" | [[Pervasive PSQL]]
| [[Pervasive Software]]
| 1982
| v11 SP3
| 2013
| {{Proprietary}}
|-
! style="text-align:left" | [[Polyhedra DBMS]]
| [[ENEA AB]]
| 1993
| 8.9
| 2014-09
| {{Proprietary}}
|-
! style="text-align:left" | [[PostgreSQL]]
| PostgreSQL Global Development Group<ref>{{Citation | url = http://www.postgresql.org/developer/ | publisher = PostgreSQL community | title = PostgreSQL development group}}</ref>
| 1989-06
| 9.3.4<ref>{{cite web |url=http://www.postgresql.org/about/news/1511/ |title=PostgreSQL Maintenance Releases: 9.3.4, 9.2.8, 9.1.13, 9.0.17, and 8.4.21 |publisher=The PostgreSQL Global Development Group |date=2014-03-20 |website=PostgreSQL |accessdate=2014-03-20}}</ref>
| 2014-03-20
| {{free|PostgreSQL Licence (a liberal Open Source license)<ref>{{Citation | url = http://www.postgresql.org/about/licence | title = License | publisher = PostgreSQL Community}}</ref>}}
|-
! style="text-align:left" | [[R:Base]]
| R:BASE Technologies<ref>{{Citation | url = http://www.rbase.com/ | title = r:Base}}</ref>
| 1982
| 9.5
|
| {{Proprietary}}
|-
! style="text-align:left" | [[RDM Server|RDM]]
| Raima Inc.<ref>{{Citation | url = http://www.raima.com/products/rdme/ | publisher = Raima Inc | title = RDM}}</ref>
| 1984
| 11.0
| 2012-06-29
| {{Proprietary}}
|-
! style="text-align:left" | [[RDM Server]]
| Raima Inc.<ref>{{Citation | url = http://www.raima.com/products/rdms/ | publisher = Raima Inc. | title = RDM Server}}</ref>
| 1993
| 8.4
| 2012-10-31
| {{Proprietary}}
|-
! style="text-align:left" | [[SAP HANA]]
| [[SAP AG]] <ref>{{Citation | url = http://saphana.com | title = Saphana.com}}</ref>
| 2010
| 1.0
| 
| {{Proprietary}}
|-
! style="text-align:left" | [[ScimoreDB]]
| Scimore<ref>{{Citation | url = http://www.scimore.com/ | title = Scimore}}</ref>
| 2005
| 3.0
| 2008-03-03
| {{Proprietary}}
|-
! style="text-align:left" | [[SmallSQL]]
| [[SmallSQL]]
| 2005-04-16
| 0.20
| 2008-12
| {{free|[[GNU Lesser General Public License|LGPL]]}}
|-
! style="text-align:left" | [[solidDB]]
| UNICOM Global
| 1992
| 7.0.0.10
| 2014-04-29
| {{Proprietary}}
|-
! style="text-align:left" | [[SQL Anywhere]]
| [[Sybase]]
| 1992
| 12.0
| 2010-07-09
| {{Proprietary}}
|-
! style="text-align:left" | [[SQLBase]]
| Unify Corp.<ref>{{Citation | url = http://www.unify.com/Products/SQLBase | publisher = Unify | series = Products | title = SQLBase}}</ref>
| 1982
| 11.5
| 2008-11
| {{Proprietary}}
|-
! style="text-align:left" | [[SQLite]]
| [[D. Richard Hipp]]
| 2000-08-17
| 3.8.0.2
| 2013-09-03 <ref>{{Citation | url = http://www.sqlite.org/changes.html | publisher = SQLite | title = SQLite Release History}}</ref>
| {{free|[[Public domain]]}}
|-
! style="text-align:left" | [[Superbase database|Superbase]]
| [[Superbase database|Superbase]]
| 1984
| Scientific (2004)
|
| {{Proprietary}}
|-
! style="text-align:left" | [[Teradata]]
| [[Teradata]]
| 1984
| 14.10
|
| {{Proprietary}}
|-
! style="text-align:left" | [[UniData]]
| Rocket Software
| 1988
| 7.2.12
| 2011-10
| {{Proprietary}}
|}

==Operating system support==
The [[operating system]]s that the RDBMSes can run on.
{| style="text-align: center; width: 95%" class="wikitable sortable"
|-
! style="width:16em" |
! [[Microsoft Windows|Windows]]
! [[OS X]]
! [[Linux]]
! [[BSD]]
! [[UNIX]]
! [[AmigaOS]]
! [[Symbian]]
! [[z/OS]]
! [[iOS]]
! [[Android (operating system)|Android]]
! [[OpenVMS]]
|-
! style="text-align:left" | [[4th Dimension (Software)|4th Dimension]]
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[ADABAS]]
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[Adaptive Server Enterprise]]
| {{yes}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{no}}
|-
! style="text-align:left" | [[Advantage Database Server]]
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[Altibase]]
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[Apache Derby]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{dunno}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[Clustrix]]
| {{no}}
| {{no}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[CUBRID]]
| {{yes}}
| {{partial}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[Drizzle (database server)|Drizzle]]
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[IBM DB2|DB2]]
| {{yes}}
| {{yes}} ([[IBM DB2 Express-C|Express C]])
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[Empress database|Empress Embedded Database]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{yes}}
| {{no}}
|-
! style="text-align:left" | [[EXASOL|EXASolution]]
| {{no}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[Firebird (database server)|Firebird]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{partial|Maybe}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[HSQLDB]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{dunno}}
| {{dunno}}
| {{no}}
|-
! style="text-align:left" | [[H2 (DBMS)|H2]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{dunno}}
| {{yes}}
| {{no}}
|-
! style="text-align:left" | [[FileMaker]]
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{Yes}}
| {{No}}
| {{no}}
|-
! style="text-align:left" | [[Informix Dynamic Server]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[Ingres (database)|Ingres]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{partial}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[InterBase]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{yes}} ([[Solaris (operating system)|Solaris]])
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[Linter SQL RDBMS]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| Under [[Linux on System z]]
| {{dunno}}
| {{yes}}
| {{no}}
|-
! style="text-align:left" | [[LucidDB]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[MariaDB]]
| {{yes}}
| {{yes}}<ref>{{cite web
|url=http://kb.askmonty.org/en/building-mariadb-on-mac-os-x-using-homebrew
|work=AskMonty KnowledgeBase
|title=Building MariaDB on Mac OS X using Homebrew
|accessdate=September 30, 2011}}</ref>
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
| {{dunno}}
| {{no}}
|-
! style="text-align:left" | [[MaxDB]]
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{partial|Maybe}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[Microsoft Access]] (JET)
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[Microsoft Visual Foxpro]]
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[Microsoft SQL Server]]
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[SQL Server Compact|Microsoft SQL Server Compact (Embedded Database)]]
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[MonetDB]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[MySQL]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}<ref>http://techotv.com/run-apache-mysql-php-http-web-server-android-os-phone-tablet/ Run Apache, Mysql, Php – Web server on Android mobile or Tablet</ref>
| {{no}}
|-
! style="text-align:left" | [[Omnis Studio]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[OpenBase|OpenBase SQL]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[OpenEdge Database|OpenEdge]]
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[Virtuoso Universal Server|OpenLink Virtuoso]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[Oracle Database|Oracle]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
|-
! style="text-align:left" | [[Oracle Rdb]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{yes}}
|-
! style="text-align:left" | [[Pervasive PSQL]]
| {{yes}}
| {{yes}} (OEM only)
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[Polyhedra DBMS|Polyhedra]]
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[PostgreSQL]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| Under Linux on System z<ref>http://www.oss4zos.org/mediawiki/index.php?title=PostgreSQL#z.2FOS</ref>
| {{no}}
| {{yes}}
| {{no}}
|-
! style="text-align:left" | [[R:Base]]
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | RDM
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[RDM Server]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[ScimoreDB]]
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[SmallSQL]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[solidDB]]
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| Under [[Linux on System z]]
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[SQL Anywhere]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{yes}}
| {{no}}
|-
! style="text-align:left" | [[SQLBase]]
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[SQLite]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{partial|Maybe}}
| {{Yes}}
| {{Yes}}
| {{no}}
|-
! style="text-align:left" | [[Superbase database|Superbase]]
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[Teradata]]
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[UniData]]
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[UniVerse]]
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|}

==Fundamental features==
Information about what fundamental RDBMS features are implemented natively.

{| style="text-align: center; width: 95%" class="wikitable sortable"
|-
! style="width:16em" |
! [[ACID]]
! [[Referential integrity]]
! [[Database transaction|Transactions]]
! Fine-grained [[Lock (computer science)|locking]]
! [[Unicode]]
! Interface
|-
! style="text-align:left" | [[4th Dimension (Software)|4th Dimension]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[graphical user interface|GUI]] & [[SQL]]
|-
! style="text-align:left" | [[ADABAS]]
| {{yes}}
| {{no}}
| {{yes}}
| {{dunno}}
| {{yes}}
| proprietary direct call & SQL (via 3rd party)
|-
! style="text-align:left" | [[Adaptive Server Enterprise]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[SQL]]
|-
! style="text-align:left" | [[Advantage Database Server]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}<sup>[[#feat 4|4]]</sup>
| [[API]] & [[SQL]]
|-
! style="text-align:left" | [[Altibase]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}} (Row-level locking)
| {{yes}}
| [[API]] & [[GUI]] & [[SQL]]
|-
! style="text-align:left" | [[Apache Derby]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[SQL]]
|-
! style="text-align:left" | [[Clustrix]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[SQL]]
|-
! style="text-align:left" | [[CUBRID]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[graphical user interface|GUI]] & [[SQL]]
|-
! style="text-align:left" | [[Drizzle (database server)|Drizzle]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[SQL]]
|-
! style="text-align:left" | [[IBM DB2|DB2]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}} (Row-level locking)<ref>[http://www-01.ibm.com/support/knowledgecenter/SSEPGG_9.7.0/com.ibm.db2.luw.admin.perf.doc/doc/c0004121.html DB2 for Linux UNIX and Windows 9.7.0>Fundamentos de DB2>Performance tuning>Factors affecting performance>Application design>Concurrency issues>Isolation levels]</ref>
| {{yes}}
| [[graphical user interface|GUI]] & [[SQL]]
|-
! style="text-align:left" | [[Empress database|Empress Embedded Database]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[graphical user interface|API]] & [[SQL]]
|-
! style="text-align:left" | [[EXASOL|EXASolution]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[graphical user interface|API]] & [[GUI]] & [[SQL]]
|-
! style="text-align:left" | [[Firebird (database server)|Firebird]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[SQL]]
|-
! style="text-align:left" | [[HSQLDB]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[SQL]]
|-
! style="text-align:left" | [[H2 (DBMS)|H2]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[SQL]]
|-
! style="text-align:left" | [[Informix Dynamic Server]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}} (Row-level locking)
| {{yes}}
| [[SQL]] and [[JSON]]
|-
! style="text-align:left" | [[Ingres (database)|Ingres]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[SQL]] & [[QUEL query languages|QUEL]]
|-
! style="text-align:left" | [[InterBase]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[SQL]]
|-
! style="text-align:left" | [[Linter SQL RDBMS]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[GUI]] & [[SQL]]
|-
! style="text-align:left" | [[LucidDB]]
| {{yes}}
| {{no}}
| {{no}}
| {{dunno}}
| {{yes}}
| [[SQL]]
|-
! style="text-align:left" | [[MariaDB]]
| {{yes}}<sup id="feat_2_back">[[#feat 2|2]]</sup>
| {{partial}}<sup id="feat_3_back">[[#feat 3|3]]</sup>
| {{yes}}<sup>[[#feat 2|2]]</sup> except for [[Data Definition Language|DDL]]<ref name="Transactional DDL in PostgreSQL">[http://wiki.postgresql.org/wiki/Transactional_DDL_in_PostgreSQL:_A_Competitive_Analysis Transactional DDL in PostgreSQL: A Competitive Analysis]</ref>
| {{yes}} (Row-level locking)
| {{yes}}
| [[SQL]]
|-
! style="text-align:left" | [[MaxDB]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[SQL]]
|-
! style="text-align:left" | [[Microsoft Access]] (JET)
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[graphical user interface|GUI]] & [[SQL]]
|-
! style="text-align:left" | [[Microsoft Visual FoxPro]]
| {{No}}
| {{Yes}}
| {{Yes}}
| {{dunno}}
| {{No}}
| [[graphical user interface|GUI]] & [[SQL]]
|-
! style="text-align:left" | [[Microsoft SQL Server]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}} (Row-level locking)<ref>[http://technet.microsoft.com/en-us/library/jj856598.aspx SQL Server Transaction Locking and Row Versioning Guide]</ref>
| {{yes}}
| [[graphical user interface|GUI]] & [[SQL]]
|-
! style="text-align:left" | [[SQL Server Compact|Microsoft SQL Server Compact (Embedded Database)]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[graphical user interface|GUI]] & [[SQL]]
|-
! style="text-align:left" | [[MonetDB]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[SQL]]
|-
! style="text-align:left" | [[MySQL]]
| {{yes}}<sup id="feat_2_back">[[#feat 2|2]]</sup>
| {{partial}}<sup id="feat_3_back">[[#feat 3|3]]</sup>
| {{yes}}<sup>[[#feat 2|2]]</sup> except for [[Data Definition Language|DDL]]<ref name="Transactional DDL in PostgreSQL"/>
| {{yes}} (Row-level locking)<ref>[http://dev.mysql.com/doc/refman/5.6/en/internal-locking.html MySQL ::   MySQL 5.6 Reference Manual :: 8.10.1 Internal Locking Methods]</ref>
| {{yes}}
| [[graphical user interface|GUI]] <sup>[[#feat 5|5]]</sup> & [[SQL]]
|-
! style="text-align:left" | [[OpenBase|OpenBase SQL]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[graphical user interface|GUI]] & [[SQL]]
|-
! style="text-align:left" | [[Oracle Database|Oracle]]
| {{yes}}
| {{yes}}
| {{yes}} except for [[Data Definition Language|DDL]]<ref name="Transactional DDL in PostgreSQL" />
| {{yes}} (Row-level locking)<ref>[http://www.dba-oracle.com/t_locks_row_level_locking_update.htm Oracle Row Lock and Row Level Locking]</ref>
| {{yes}}
| [[API]] & [[graphical user interface|GUI]] & [[SQL]]
|-
! style="text-align:left" | [[Oracle Rdb]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[SQL]]
|-
! style="text-align:left" | [[Virtuoso Universal Server|OpenLink Virtuoso]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[API]] & [[graphical user interface|GUI]] & [[SQL]]
|-
! style="text-align:left" | [[Pervasive PSQL]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}<sup>[[#feat 6|6]]</sup>
| [[API]] & [[graphical user interface|GUI]] & [[SQL]]
|-
! style="text-align:left" | [[Polyhedra DBMS]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}} (optimistic and pessimistic cell-level locking)<ref>[developer.polyhedra.com/history/polyhedra-8-7 Polyhedra 8.7 new headline feature: locking]</ref>
| {{yes}}
| [[API]] & [[SQL]]
|-
! style="text-align:left" | [[PostgreSQL]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}} (Row-level locking)<ref>[http://www.postgresql.org/docs/devel/enwiki/static/explicit-locking.html PostgreSQL: Documentation: devel: Explicit Locking]</ref>
| {{yes}}
| [[API]] & [[graphical user interface|GUI]] & [[SQL]]
|-
! style="text-align:left" | RDM
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[SQL]] & [[API]]
|-
! style="text-align:left" | [[RDM Server]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[SQL]] & [[API]]
|-
! style="text-align:left" | [[ScimoreDB]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{partial}}
| [[SQL]]
|-
! style="text-align:left" | [[solidDB]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}} (Row-level locking)
| {{yes}}
| [[API & SQL]]
|-
! style="text-align:left" | [[SQL Anywhere]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[SQL]]
|-
! style="text-align:left" | [[SQLBase]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[API]] & [[graphical user interface|GUI]] & [[SQL]]
|-
! style="text-align:left" | [[SQLite]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}} (Database-level locking)<ref>[https://www.sqlite.org/lockingv3.html File Locking And Concurrency In SQLite Version 3]</ref>
| {{optional}}<ref>[http://www.sqlite.org/faq.html#q18 SQLite Full Unicode support is optional and not installed by default in most systems] (like [[Android (operating system)|Android]], [[Debian]]…)</ref>
| [[API]] & [[SQL]]
|-
! style="text-align:left" | [[Teradata]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| [[SQL]]
|-
! style="text-align:left" | [[UniData]]
| {{yes}}
| {{no}}
| {{yes}}
| {{dunno}}
| {{yes}}
| Multiple
|-
! style="text-align:left" | [[UniVerse]]
| {{yes}}
| {{no}}
| {{yes}}
| {{dunno}}
| {{yes}}
| Multiple
|- class="sortbottom"
!
![[ACID]]
![[Referential integrity]]
![[Database transaction|Transactions]]
!Fine-grained [[Lock (computer science)|locking]]
![[Unicode]]
!Interface
|}

<cite id="feat_1">[[Comparison of relational database management systems#feat 1|Note (1):]]</cite> Currently only supports read uncommited transaction isolation. Version 1.9 adds serializable isolation and version 2.0 will be fully ACID compliant.

<cite id="feat_2">[[#feat 2 back|Note (2):]]</cite> MySQL provides ACID compliance through the default InnoDB storage engine.<ref>{{cite web|url=http://dev.mysql.com/doc/refman/5.5/en/innodb-storage-engine.html|title=MySQL - The InnoDB Storage Engine}}</ref><ref>{{cite web|url=http://wiki.oracle.com/page/InnoDB|title=InnoDB - Oracle Wiki}}</ref>

<cite id="feat_3">[[#feat 3 back|Note (3):]]</cite> "For other [than InnoDB] storage engines, MySQL Server parses and ignores the FOREIGN KEY and REFERENCES syntax in CREATE TABLE statements. The CHECK clause is parsed but ignored by all storage engines."<ref>{{cite web|url=http://dev.mysql.com/doc/refman/5.6/en/create-table.html|title=MySQL 5.6 Reference Manual}}</ref>

<cite id="feat_4">[[Comparison of relational database management systems#feat 4|Note (4):]]</cite> Support for Unicode is new in version 10.0.

<cite id="feat_5">[[Comparison of relational database management systems#feat 5|Note (5):]]</cite> MySQL provides GUI interface through [[MySQL Workbench]].

==Limits==
Information about data size limits.
{| style="text-align: center; width: 95%" class="wikitable sortable"
|-
! style="width:12em" |
! Max DB size
! Max table size
! Max row size
! Max columns per row
! Max Blob/Clob size
! Max CHAR size
! Max NUMBER size
! Min DATE value
! Max DATE value
! Max column name size
|-
! style="text-align:left" | [[4th Dimension (Software)|4th Dimension]]
| Limited
| ?
| ?
| 65,135
| 200 GB (2 [[gibibyte|GiB]] [[Unicode]])
| 200 GB (2 [[gibibyte|GiB]] [[Unicode]])
| 64 bits
| ?
| ?
| ?
|-
! style="text-align:left" | [[Advantage Database Server]]
| Unlimited
| 16 [[exbibyte|EiB]]
| 65,530 B
| 65,135 / (10+ AvgFieldNameLength)
| 4 [[gibibyte|GiB]]
| ?
| 64 bits
| ?
| ?
| 128
|-
! style="text-align:left" | [[Apache Derby]]
| Unlimited
| Unlimited
| Unlimited
| 1,012 (5,000 in views)
| 2,147,483,647 chars
| 254 (<code>VARCHAR</code>: 32,672)
| 64 bits
| 0001-01-01
| 9999-12-31
| 128
|-
! style="text-align:left" | [[Clustrix]]
| Unlimited
| Unlimited
| 64 MB on Appliance, 4 MB on AWS
| ?
| 64 MB
| 64 MB
| 64 MB
| 0001-01-01
| 9999-12-31
| 254
|-
! style="text-align:left" | [[CUBRID]]
| 2 EB
| 2 EB
| Unlimited
| 6400
| Unlimited
| 1 GB
| 64 bits
| 0001-01-01
| 9999-12-31
| 254
|-
! style="text-align:left" | [[Drizzle (database server)|Drizzle]]
| Unlimited
| 64 TB
| 8 KB
| 1,000
| 4 GB (longtext, longblob)
| 64 KB (text)
| 64 bits
| 0001
| 9999
| 64
|-
! style="text-align:left" | [[IBM DB2|DB2]]
| Unlimited
| 2 [[zettabyte|ZB]]
| 32,677 B
| 1,012
| 2 GB
| 32 [[kibibyte|KiB]])
| 64 bits
| 0001-01-01
| 9999-12-31
| 128
|-
! style="text-align:left" | [[Empress database|Empress Embedded Database]]
| Unlimited
| 2<sup>63</sup>-1 bytes
| 2 GB
| 32,767
| 2 GB
| 2 GB
| 64 bits
| 0000-01-01
| 9999-12-31
| 32
|-
! style="text-align:left" | [[EXASOL|EXASolution]]
| Unlimited
| Unlimited
| Unlimited
| 10,000
| N/A
| 2 MB
| 128 bits
| 0001-01-01
| 9999-12-31
| 256
|-
! style="text-align:left" | [[FileMaker]]
| 8 TB
| 8 TB
| 8 TB
| 256,000,000
| 4 GB
| 10^9 characters
| 10^9 numbers w/ range 10^-400 to 10^400
| 0001-01-01
| 4000-12-31
| 100
|-
! style="text-align:left" | [[Firebird (database server)|Firebird]]
|Unlimited<sup id="limit_1_back">[[#limit 1|1]]</sup>
| ~32 TB
| 65,536 B
| Depends on data types used
| 2 GB
| 32,767 B
| 64 bits
| 100
| 32768
| 31
|-
! style="text-align:left" | [[HSQLDB]]
| 64 TB
| Unlimited<sup id="limit_8_back">[[#limit 8|8]]</sup>
| Unlimited<sup id="limit_8_back">[[#limit 8|8]]</sup>
| Unlimited<sup id="limit_8_back">[[#limit 8|8]]</sup>
| 64 TB<sup id="limit_7_back">[[#limit 7|7]]</sup>
| Unlimited<sup id="limit_8_back">[[#limit 8|8]]</sup>
| Unlimited<sup id="limit_8_back">[[#limit 8|8]]</sup>
| 0001-01-01
| 9999-12-31
| 128
|-
! style="text-align:left" | [[H2 (DBMS)|H2]]
| 64 TB
| Unlimited<sup id="limit_8_back">[[#limit 8|8]]</sup>
| Unlimited<sup id="limit_8_back">[[#limit 8|8]]</sup>
| Unlimited<sup id="limit_8_back">[[#limit 8|8]]</sup>
| 64 TB<sup id="limit_7_back">[[#limit 7|7]]</sup>
| Unlimited<sup id="limit_8_back">[[#limit 8|8]]</sup>
| 64 bits
| -99999999
| 99999999
| Unlimited<sup id="limit_8_back">[[#limit 8|8]]</sup>
|-
! style="width:16em" |
! Max DB size
! Max table size
! Max row size
! Max columns per row
! Max Blob/Clob size
! Max CHAR size
! Max NUMBER size
! Min DATE value
! Max DATE value
! Max column name size
|-
! style="text-align:left" | [[Informix Dynamic Server]]
| ~128 PB
| ~128 PB
| 32,765 bytes (exclusive of large objects)
| 32,765
| 4 TB
| 32,765
| 10<sup>32</sup>
| 01/01/0001<sup id="limit_10_back">[[#limit 10|10]]</sup>
| 12/31/9999
| 128 bytes
|-
! style="text-align:left" | [[Ingres (database)|Ingres]]
| Unlimited
| Unlimited
| 256 KB
| 1,024
| 2 GB
| 32 000 B
| 64 bits
| 0001
| 9999
| 256
|-
! style="text-align:left" | [[InterBase]]
|Unlimited<sup id="limit_1_back">[[#limit 1|1]]</sup>
| ~32 TB
| 65,536 B
| Depends on data types used
| 2 GB
| 32,767 B
| 64 bits
| 100
| 32768
| 31
|-
! style="text-align:left" | [[Linter SQL RDBMS]]
| Unlimited
| 2<sup>30</sup> rows
| 64 KB (w/o BLOBs), 4 GB (BLOB)
| 250
| 4 GB
| 4 KB
| 64 bits
| 0001-01-01
| 9999-12-31
| 66
|-
! style="text-align:left" | [[MariaDB]] 10
| Unlimited
| MyISAM storage limits: 256 TB; Innodb storage limits: 64 TB; Aria storage limits: ???
| 64 KB<sup id="limit_3_back">[[#limit 3|3]]</sup>
| 4,096<sup id="limit_4_back">[[#limit 4|4]]</sup>
| 4 GB (longtext, longblob)
| 64 KB (text)
| 64 bits
| 1000
| 9999
| 64<ref name="maria_identifiers">{{cite web | url=https://mariadb.com/kb/en/mariadb/documentation/sql-language-structure/identifier-names/ | title=Identifier Names | publisher=MariaDB KnowledgeBase | accessdate=26 September 2014}}</ref>
|-
! style="text-align:left" | [[Microsoft Access]] (JET)
| 2 GB
| 2 GB
| 16 MB
| 255
| 64 KB (memo field), 1 GB ("OLE Object" field)
| 255 B (text field)
| 32 bits
| 0100
| 9999
| 64
|-
! style="text-align:left" | [[Microsoft Visual Foxpro]]
| Unlimited
| 2 GB
| 65,500 B
| 255
| 2 GB
| 16 MB
| 32 bits
| 0001
| 9999
| 10
|-
! style="text-align:left" | [[Microsoft SQL Server]]
| 524,272 TB (32 767 files * 16 TB max file size)
| 524,272 TB
| 8,060 bytes (Unlimited)<sup id="limit_6_back">[[#limit 6|6]]</sup>
| 30,000
| 2 GB
| 2 GB<sup id="limit_6_back">[[#limit 6|6]]</sup>
| 126 bits<sup id="limit_2_back">[[#limit 2|2]]</sup>
| 0001
| 9999
| 128
|-
! style="text-align:left" | [[SQL Server Compact|Microsoft SQL Server Compact (Embedded Database)]]
| 4 GB
| 4 GB
| 8,060 bytes
| 1024
| 2 GB
| 4000
| 154 bits
| 0001
| 9999
| 128
|-
! style="text-align:left" | [[MonetDB]]
| Unlimited
| Unlimited
| Unlimited
| Unlimited
| Unlimited
| Unlimited
| 64 bits
| 0
| 9999-12-31
| ?
|-
! style="text-align:left" | [[MySQL]] 5
| Unlimited
| MyISAM storage limits: 256 TB; Innodb storage limits: 64 TB
| 64 KB<sup id="limit_3_back">[[#limit 3|3]]</sup>
| 4,096<sup id="limit_4_back">[[#limit 4|4]]</sup>
| 4 GB (longtext, longblob)
| 64 KB (text)
| 64 bits
| 1000
| 9999
| 64
|-
! style="text-align:left" | [[Virtuoso Universal Server|OpenLink Virtuoso]]
| 32 TB per instance (Unlimited via elastic cluster)
| DB size (or 32 TB)
| 4 KB
| 200
| 2 GB
| 2 GB
| 2<sup>31</sup>
| 0
| 9999
| 100
|-
! style="text-align:left" | [[Oracle Database|Oracle]]
| Unlimited (4 GB * block size per tablespace)
| 4 GB * block size (with BIGFILE tablespace)
| 8 KB
| 1,000
| 128 TB
| 32,767 B<sup id="limit_11_back">[[#limit 11|11]]</sup>
| 126 bits
| −4712
| 9999
| 30
|-
! style="width:16em" |
! Max DB size
! Max table size
! Max row size
! Max columns per row
! Max Blob/Clob size
! Max CHAR size
! Max NUMBER size
! Min DATE value
! Max DATE value
! Max column name size
|-
! style="text-align:left" | [[Pervasive PSQL]]
| 4 billion objects
| 256&nbsp;GB
| 2&nbsp;GB
| 1,536
| 2&nbsp;GB
| 8,000&nbsp;bytes
| 64&nbsp;bits
| 01-01-0001
| 12-31-9999
| 128&nbsp;bytes
|-
! style="text-align:left" | [[Polyhedra DBMS|Polyhedra]]
| Limited by available RAM, address space
| 2<sup>32</sup> rows
| Unlimited
| 65,536
| 4&nbsp;GB (subject to RAM)
| 4&nbsp;GB (subject to RAM)
| 64&nbsp;bits
| 0001-01-01
| 8000-12-31
| 255
|-
! style="text-align:left" | [[PostgreSQL]]
| Unlimited
| 32&nbsp;TB
| 1.6&nbsp;TB
| 250–1600 depending on type
| 1&nbsp;GB (text, bytea)<ref>http://grokbase.com/t/postgresql/pgsql-general/12bsww982c/large-insert-leads-to-invalid-memory-alloc</ref> - stored inline or 4&nbsp;TB (stored in pg_largeobject)<ref>http://www.postgresql.org/docs/9.3/enwiki/static/lo-intro.html</ref> 
| 1&nbsp;GB
| Unlimited
| −4,713
| 5,874,897
| 63
|-
! style="text-align:left" | [[RDM Embedded]]
| Unlimited
| 2<sup>48</sup>-1 rows
| 32&nbsp;KB
| 1,000
| 4&nbsp;GB
| char: 256, varchar: 4 KB
| 64&nbsp;bits
| 0001-01-01
| 11758978-12-31
| 31
|-
! style="text-align:left" | [[RDM Server]]
| Unlimited
| 2<sup>64</sup>-1 rows
| 32&nbsp;KB
| 32,768
| Unlimited
| 32&nbsp;KB
| 64&nbsp;bits
| 0001-01-01
| 11758978-12-31
| 32
|-
! style="text-align:left" | [[ScimoreDB]]
| Unlimited
| 16 EB
| 8,050 B
| 255
| 16 TB
| 8,000 B
| 64 bits
| ?
| ?
| ?
|-
! style="text-align:left" | [[solidDB]]
| 256 TB
| 256 TB
| 32 KB + BLOB data
| Limited by row size
| 4 GB
| 4 GB
| 64 bits
| -32768-01-01
| 32767-12-31
| 254
|-
! style="text-align:left" | [[SQL Anywhere]]
| 104 TB (13 files, each file up to 8 TB (32 KB pages))
| Limited by file size
| Limited by file size
| 45,000
| 2 GB
| 2 GB
| 64 bits
| 0001-01-01
| 9999-12-31
| ?
|-
! style="text-align:left" | [[SQLite]]
| 128 TB (2<sup>31</sup> pages * 64 KB max page size)
| Limited by file size
| Limited by file size
| 32,767
| 2 GB
| 2 GB
| 64 bits
| No DATE type<sup id="limit_9_back">[[#limit 9|9]]</sup>
| No DATE type<sup id="limit_9_back">[[#limit 9|9]]</sup>
| Unlimited
|-
! style="text-align:left" | [[Teradata]]
| Unlimited
| Unlimited
| 64 KB wo/lobs (64 GB w/lobs)
| 2,048
| 2 GB
| 10,000
| 64 bits
| ?
| 9999-12-31  Select 80991231 (date);
| 30
|-
! style="text-align:left" | [[UniVerse]]
| Unlimited
| Unlimited
| Unlimited
| Unlimited
| Unlimited
| Unlimited
| Unlimited
| Unlimited
| Unlimited
| Unlimited
|-
!
! Max DB size
! Max table size
! Max row size
! Max columns per row
! Max Blob/Clob size
! Max CHAR size
! Max NUMBER size
! Min DATE value
! Max DATE value
! Max column name size
|}

<cite id="limit_1">[[#limit 1 back|Note (1):]]</cite> Firebird 2.x maximum database size is effectively unlimited with the largest known database size >980 GB.<ref>{{Citation | url = http://www.firebirdsql.org/index.php?op=guide&id=techspec | publisher = Firebird SQL | series = Guide | title = Technical Specifications}}</ref>  Firebird 1.5.x maximum database size: 32 TB.

<cite id="limit_2">[[#limit 2 back|Note (2):]]</cite> Limit is 10<sup>38</sup> using <code>DECIMAL</code> datatype.<ref>{{Citation | url = http://msdn.microsoft.com/en-us/library/ms187746.aspx | publisher = Microsoft | series = MSDN | title = Library}}</ref>

<cite id="limit_3">[[#limit 3 back|Note (3):]]</cite> InnoDB is limited to 8,000 bytes (excluding <code>VARBINARY</code>, <code>VARCHAR</code>, <code>BLOB</code>, or <code>TEXT</code> columns).<ref name = "MySQL column count limit">{{Citation | url = http://dev.mysql.com/doc/refman/5.1/en/column-count-limit.html | publisher = Oracle | series = MySQL Documentation | title = Reference Manual | number = 5.1 | chapter = Column count limit}}</ref>

<cite id="limit_4">[[#limit 4 back|Note (4):]]</cite> InnoDB is limited to 1,000 columns.<ref name = "MySQL column count limit" />

<cite id="limit_6">[[#limit 6 back|Note (6):]]</cite> Using <code>VARCHAR (MAX)</code> in SQL 2005 and later.<ref name = "SQL Server Row-Overflow Data Exceeding 8 KB">{{Citation | url = http://technet.microsoft.com/en-us/library/ms186981.aspx | publisher = Microsoft | series = SQL Server Documentation | title = TechNet Library | number = 2012 | chapter = Row-Overflow Considerations}}</ref>

<cite id="limit_7">[[#limit 7 back|Note (7):]]</cite> When using a page size of 32 KB, and when BLOB/CLOB data is stored in the database file.

<cite id="limit_8">[[#limit 8 back|Note (8):]]</cite> Java array size limit of 2,147,483,648 (2<sup>31</sup>) objects per array applies.  This limit applies to number of characters in names, rows per table, columns per table, and characters per <code>CHAR</code>/<code>VARCHAR</code>.

<cite id="limit_9">[[#limit 9 back|Note (9):]]</cite> Despite the lack of a date datatype, SQLite does include date and time functions,<ref>{{Citation | url = http://www.sqlite.org/lang_datefunc.html | publisher = SQLite | title = Language | chapter = Date functions}}</ref> which work for timestamps between 0000-01-01 00:00:00 and 5352-11-01 10:52:47.

<cite id="limit_10">[[#limit 10 back|Note (10):]]</cite> Informix DATETIME type has adjustable range from YEAR only through 1/10000th second.  DATETIME date range is 0001-01-01 00:00:00.00000 through 9999-12-31 23:59:59.99999.

<cite id="limit_11">[[#limit 11 back|Note (11):]]</cite> Since version 12c. Earlier versions support up to 4000 B.

==Tables and views==
Information about what [[table (database)|table]]s and [[View (database)|view]]s (other than basic ones) are supported natively.

{| style="text-align: center; width: 95%" class="wikitable sortable"
|-
! style="width:16em" |
! Temporary table
! [[Materialized view]]
|-
! style="text-align:left" | [[4th Dimension (Software)|4th Dimension]]
| {{Yes}}
| {{no}}
|-
! style="text-align:left" | [[ADABAS]]
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[Adaptive Server Enterprise]]
| {{yes}}<sup id="tb_1_back">[[#tb 1|1]]</sup>
| {{yes}} - see precomputed result sets
|-
! style="text-align:left" | [[Advantage Database Server]]
| {{yes}}
| {{no}} (only common views)
|-
! style="text-align:left" | [[Altibase]]
| {{yes}}
| {{no}} (only common views)
|-
! style="text-align:left" | [[Apache Derby]]
| {{yes}}
| {{no}}
|-
! style="text-align:left" | [[Clustrix]]
| {{yes}}
| {{no}}
|-
! style="text-align:left" | [[CUBRID]]
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[Drizzle (database server)|Drizzle]]
| {{yes}}
| {{no}}<sup id="tb_4_back">[[#tb 4|4]]</sup>
|-
! style="text-align:left" | [[IBM DB2|DB2]]
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[Empress database|Empress Embedded Database]]
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[EXASOL|EXASolution]]
| {{yes}}
| {{no}}
|-
! style="text-align:left" | [[Firebird (database server)|Firebird]]
| {{yes}}
| {{no}} (only common views)
|-
! style="text-align:left" | [[HSQLDB]]
| {{yes}}
| {{no}}
|-
! style="text-align:left" | [[H2 (DBMS)|H2]]
| {{yes}}
| {{no}}
|-
! style="text-align:left" | [[Informix Dynamic Server]]
| {{yes}}
| {{no}}<sup id="tb_2_back">[[#tb 2|2]]</sup>
|-
! style="text-align:left" | [[Ingres (database)|Ingres]]
| {{yes}}
| {{no}}
|-
! style="text-align:left" | [[InterBase]]
| {{yes}}
| {{no}}
|-
! style="text-align:left" | [[Linter SQL RDBMS]]
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[LucidDB]]
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[MariaDB]]
| {{yes}}
| {{no}}<sup id="tb_4_back">[[#tb 4|4]]</sup>
|-
! style="text-align:left" | [[MaxDB]]
| {{yes}}
| {{no}}
|-
! style="text-align:left" | [[Microsoft Access]] (JET)
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[Microsoft Visual Foxpro]]
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[Microsoft SQL Server]]
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[SQL Server Compact|Microsoft SQL Server Compact (Embedded Database)]]
| {{yes}}
| {{no}}
|-
! style="text-align:left" | [[MonetDB]]
| {{yes}}
| {{no}}
|-
! style="text-align:left" | [[MySQL]]
| {{yes}}
| {{no}}<sup id="tb_4_back">[[#tb 4|4]]</sup>
|-
! style="text-align:left" | [[OpenBase|OpenBase SQL]]
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[Oracle Database|Oracle]]
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[Oracle Rdb]]
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[Virtuoso Universal Server|OpenLink Virtuoso]]
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[Pervasive PSQL]]
| {{yes}}
| {{no}}
|-
! style="text-align:left" | [[Polyhedra DBMS]]
| {{no}}
| {{no}} (only common views)
|-
! style="text-align:left" | [[PostgreSQL]]
| {{yes}}
| {{yes}}<sup id="tb_5_back">[[#tb 5|5]]</sup>
|-
! style="text-align:left" | [[RDM Embedded]]
| {{yes}}
| {{no}}
|-
! style="text-align:left" | [[RDM Server]]
| {{yes}}
| {{no}}
|-
! style="text-align:left" | [[solidDB]]
| {{yes}}
| {{no}} (only common views)
|-
! style="text-align:left" | [[SQL Anywhere]]
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[ScimoreDB]]
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[SQLite]]
| {{yes}}
| {{no}}
|-
! style="text-align:left" | [[Teradata]]
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[UniData]]
| {{yes}}
| {{no}}
|-
! style="text-align:left" | [[UniVerse]]
| {{yes}}
| {{no}}
|}

<cite id="tb_1">[[#tb 1 back|Note (1):]]</cite> Server provides tempdb, which can be used for public and private (for the session) temp tables.<ref>{{Citation | url = http://sybooks.sybase.com/onlinebooks/group-as/asg1250e/sag/@Generic__BookTextView/3225; | publisher = Sybase | title = Online books}}</ref>

<cite id="tb_2">[[#tb 2 back|Note (2):]]</cite> Materialized views are not supported in Informix; the term is used in IBM’s documentation to refer to a temporary table created to run the view’s query when it is too complex, but one cannot for example define the way it is refreshed or build an index on it.  The term is defined in the Informix Performance Guide.<ref>{{Citation | publisher = IBM | url = http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=/com.ibm.perf.doc/ids_prf_534.htm | series = Info Centre | title = Informix Performance Guide}}</ref>

<cite id="tb_4">[[#tb 4 back|Note (4):]]</cite> Materialized views can be emulated using [[stored procedure]]s and triggers.<ref>{{Citation | publisher = Red Noize | series = Pure | title = Archives | number = 13 | url = http://pure.rednoize.com/archives/13/}}</ref>

<cite id="tb_5">[[#tb 5 back|Note (5):]]</cite> Materialized views are now standard but can be emulated in versions prior to 9.3 with stored procedures and triggers using [[PL/pgSQL]], [[PL/Perl]], PL/Python, or other procedural languages.<ref>{{Citation | publisher = Jonathan Gardner | title = PostgreSQL | url = http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html | chapter = Materialized Views}}</ref>

==Indices==
Information about what [[index (database)|indices]] (other than basic [[B-tree|B-]]/[[B+ tree]] indices) are supported natively.
{| style="text-align: center; width: 95%" class="wikitable sortable"
|-
! style="width:16em" |
! [[R-tree|R-]]/[[R+ tree]]
! [[Hash function|Hash]]
! [[Expression index|Expression]]
! [[Partial index|Partial]]
! [[Reverse index|Reverse]]
! [[Bitmap index|Bitmap]]
! [[GiST]]
! [[Inverted index|GIN]]
! [[Full text search|Full-text]]
! [[Spatial index|Spatial]]
! [[Forest of Trees|FOT]]
|-
! style="text-align:left" | [[4th Dimension (Software)|4th Dimension]]
| {{dunno}}
| style="background:#ffd;"| Cluster
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{yes}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[ADABAS]]
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[Adaptive Server Enterprise]]
| {{no}}
| {{no}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{yes}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[Advantage Database Server]]
| {{no}}
| {{no}}
| {{yes}}
| {{no}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[Apache Derby]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}<ref>{{Citation | url = https://issues.apache.org/jira/browse/DERBY-472 | chapter = Derby | title = Full Text Indexing,  Search | publisher = Apache | series = Issues}}</ref>
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[Clustrix]]
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[CUBRID]]
| {{no}}
| {{no}}
| {{yes}}<ref name="CUBRID 9.0 release">{{cite web|url=http://www.cubrid.org/blog/news/announcing-cubrid-9-0-with-3x-performance-increase-and-sharding-support/|title=CUBRID 9.0 release}}</ref>
| {{yes}}<ref name="CUBRID 9.0 release"/>
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[Drizzle (database server)|Drizzle]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[IBM DB2|DB2]]
| {{no}}
| {{dunno}}
| {{yes}}
| {{no}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}<ref>{{Citation | url = http://www.ibm.com/developerworks/data/tutorials/dm-0810shettar/ | publisher = IBM | series = Developer Works | title = Full-text search with DB2 Text Search}}</ref>
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[Empress database|Empress Embedded Database]]
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[EXASOL|EXASolution]]
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[Firebird (database server)|Firebird]]
| {{no}}
| {{no}}
| {{yes}}
| {{no}}
| {{yes}}&nbsp;<sup id="idx_1_back">[[#idx 1|1]]</sup>
| {{no}}
| {{no}}
| {{no}}
| {{no}}<ref>{{Citation | url = http://www.firebirdfaq.org/faq328/ | publisher = Firebird FAQ | title = Does Firebird support full-text search?}}</ref>
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[HSQLDB]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[H2 (DBMS)|H2]]
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{yes}}<ref>{{Citation | url = http://www.h2database.com/html/tutorial.html#fulltext | publisher = H2 Database | title = Fulltext Search | series = Tutorial}}</ref>
| {{yes}}<ref>{{Citation | url = http://www.h2database.com/html/grammar.html#create_index | publisher = H2 Database | title = Create Spatial Index | series = Grammar}}</ref>
| {{dunno}}
|-
! style="text-align:left" | [[Informix Dynamic Server]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}<ref>{{Citation | url = http://publib.boulder.ibm.com/infocenter/idshelp/v117/index.jsp?topic=%2Fcom.ibm.perf.doc%2Fids_prf_763.htm | publisher = IBM | title = Forest of Trees Index | series = Informix Infocenter}}</ref>
|-
! style="text-align:left" | [[Ingres (database)|Ingres]]
| {{yes}}
| {{yes}}
| {{yes|Ingres v10}}
| {{no}}
| {{no}}
| {{yes|Ingres v10}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[InterBase]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[Linter SQL RDBMS]]<sup id="os_10_back">[[#os 10|10]]</sup>
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{yes}}<ref>{{Citation | url = http://linter.ru/en/documentation/pdf/phrase.pdf | publisher = Linter | place = RU | series = Documentation | title = Full Text Search Functions | format = PDF}}</ref>
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[LucidDB]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[MariaDB]]
| style="background:#ffd;"| MyISAM tables only
| style="background:#ffd;"| MEMORY, Cluster (NDB), InnoDB,<sup id="idx_5_back">[[#idx 5|5]]</sup> tables only
| style="background:#ffd;" | PERSISTENT virtual columns only <ref>{{Citation | url = https://mariadb.com/kb/en/virtual-columns/}}</ref>
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| style="background:#ffd;"| MyISAM tables<ref name="Bugs">{{Citation | publisher = Oracle | series = MySQL | url = http://bugs.mysql.com/bug.php?id=13979 | title = Bugs | chapter = Feature request #13979: InnoDB engine doesn't support FULLTEXT}}</ref> and, since v10.0.5, InnoDB tables<ref>{{Citation | publisher = MariaDB | series = MariaDB | url = https://mariadb.com/kb/en/mariadb-1005-release-notes/ | title = Release Notes | chapter = MariaDB v10.0.5 Release Notes}}</ref>
| style="background:#ffd;"| MyISAM tables only<ref name="Creating Spatial Indexes">{{Citation | publisher = Oracle | series = MySQL | url = http://dev.mysql.com/doc/refman/5.0/en/creating-spatial-indexes.html | title = Creating Spatial Indexes}}</ref>
| {{dunno}}
|-
! style="text-align:left" | [[MaxDB]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[Microsoft Access]] (JET)
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}<ref>{{Citation | url = http://stackoverflow.com/questions/399406/does-microsoft-access-have-full-text-search | publisher = Stack Overflow | series = Questions | title = Does Microsoft Access have Full Text Search?}}</ref>
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[Microsoft Visual Foxpro]]
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}<sup id="idx_2_back">[[#idx 2|2]]</sup>
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[Microsoft SQL Server]]
| {{dunno}}
| style="background:#ffd;"| Non/Cluster & fill factor
| {{yes}}<sup id="idx_3_back">[[#idx 3|3]]</sup>
| {{yes}}<sup id="idx_4_back">[[#idx 4|4]]</sup>
| {{no}}<sup>[[#idx 3|3]]</sup>
| {{no}}
| {{no}}
| {{no}}
| {{yes}}<ref>{{Citation | publisher = Microsoft | series = MSDN | url = http://msdn.microsoft.com/en-us/library/ms142571.aspx | title = Library | chapter = Microsoft SQL Server Full-Text Search}}</ref>
| {{yes}}<ref>{{Citation | publisher = Microsoft | series = Tech Net | url = http://technet.microsoft.com/en-us/library/bb964712.aspx | title = Library | chapter = Spatial Indexing Overview}}</ref>
| {{dunno}}
|-
! style="text-align:left" | [[SQL Server Compact|Microsoft SQL Server Compact (Embedded Database)]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}<ref>{{Citation | publisher = Microsoft | series = MSDN | url = http://social.msdn.microsoft.com/Forums/en-US/sqlce/thread/4a8af1a6-c644-41a5-8637-c7c5a6d73a4c | title = Forums | chapter = Microsoft SQL Server Compact Full-text search is not available}}</ref>
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[MonetDB]]
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[MySQL]]
| style="background:#ffd;"| MyISAM tables only
| style="background:#ffd;"| MEMORY, Cluster (NDB), InnoDB,<sup id="idx_5_back">[[#idx 5|5]]</sup> tables only
| {{no}}<ref>{{Citation | publisher = Oracle | series = MySQL | url = http://bugs.mysql.com/bug.php?id=4990 | title = Bugs | chapter = Feature request #4990: Functional Indexes}}</ref>
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| style="background:#ffd;"| MyISAM tables<ref name="Bugs"/> and, since v5.6.4, InnoDB tables<ref>{{Citation | publisher = Oracle | series = MySQL | url = http://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-4.html | title = Release Notes | chapter = MySQL v5.6.4 Release Notes}}</ref>
| style="background:#ffd;"| MyISAM tables only<ref name="Creating Spatial Indexes"/>
| {{dunno}}
|-
! style="text-align:left" | [[Oracle Database|Oracle]]
| {{yes}}&nbsp;<sup id="idx_1_back">[[#idx 11|11]]</sup>
| style="background:#ffd;"| Cluster Tables
| {{yes}}
| {{yes}}&nbsp;<sup id="idx_6_back">[[#idx 6|6]]</sup>
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}<ref>{{Citation | url = http://stackoverflow.com/questions/202623/does-oracle-support-full-text-search | publisher = Stack Overflow | series = Questions | title = Does Oracle support full text search?}}</ref>
| {{yes}}<ref>{{Citation | publisher = Oracle | series = Tech Network | url = http://www.oracle.com/technetwork/database/options/spatial/ | title = Spatial &  Locator | chapter = Location Features for Database 11g}}</ref>
| {{dunno}}
|-
! style="text-align:left" | [[Oracle Rdb]]
| {{No}}
| {{Yes}}
| {{dunno}}
| {{No}}
| {{No}}
| {{dunno}}
| {{No}}
| {{No}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[Virtuoso Universal Server|OpenLink Virtuoso]]
| {{yes}}
| style="background:#ffd;"| Cluster
| {{yes}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}} (Commercial only)
| {{no}}
|-
! style="text-align:left" | [[Pervasive PSQL]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[Polyhedra DBMS]]
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[PostgreSQL]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}<sup id="idx_7_back">[[#idx 7|7]]</sup>
| {{yes}}<sup id="idx_8_back">[[#idx 8|8]]</sup>
| {{yes}}
| {{yes}}
| {{yes}}<ref>{{Citation | publisher = PostgreSQL community | series = Documentation | number = 8.4 | url = http://www.postgresql.org/docs/8.4/enwiki/static/textsearch.html | title = Full Text Search]}}</ref>
| style="background:#ffd;"| PostGIS<ref>{{Citation | publisher = Refractions | series = PostGIS | url = http://postgis.refractions.net/documentation/manual-1.5/ch04.html#id2638705 | title = Manual | chapter = 4}}</ref>
| {{dunno}}
|-
! style="text-align:left" | [[RDM Embedded]]
| {{no}}
| {{yes}}
| {{no}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[RDM Server]]
| {{no}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[ScimoreDB]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{yes}}<ref>{{Citation | url = http://www.scimore.com/howto/getstarted/google-like-sql-freetext/ | series = ScimoreDB | title = How to get started | title = Free text search queries in SQL}}</ref>
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[solidDB]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[SQL Anywhere]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{yes}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[SQLite]]
| {{yes}}<ref>[http://www.sqlite.org/rtree.html The SQLite R*Tree Module]</ref>
| {{no}}
| {{no}}
| {{yes}}<ref>[http://sqlite.org/partialindex.html SQLite Partial Indexes]</ref>
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{yes}}<ref>[http://www.sqlite.org/fts3.html SQLite FTS3 Extension]</ref>
| style="background:#ffd;"| SpatiaLite<ref>{{Citation | url = http://www.gaia-gis.it/spatialite/ | publisher = Gaia GIS | place = IT | title = SpatiaLite | number = 2.3.1}}</ref>
| {{dunno}}
|-
! style="text-align:left" | [[Teradata]]
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{dunno}}<ref>{{Citation | url = http://www.info.teradata.com/FullText/eFull-Text-Srch.cfm | publisher = Teradata | series = Online Publications | title = Full-Text Search}}</ref>
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[UniVerse]]
| {{yes}}
| {{yes}}
| {{yes}}<sup id="idx_3_back">[[#idx 3|3]]</sup>
| {{yes}}<sup id="idx_3_back">[[#idx 3|3]]</sup>
| {{yes}}<sup id="idx_3_back">[[#idx 3|3]]</sup>
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
| {{yes}}<ref>[[Teradata Geospatial|geospatial]]</ref>
| {{dunno}}
|- |
!
! [[R-tree|R-]]/[[R+ tree]]
! [[Hash function|Hash]]
! [[Expression (programming)|Expression]]
! [[Partial index|Partial]]
! [[Reverse index|Reverse]]
! [[Bitmap Index|Bitmap]]
! [[GiST]]
! [[Generalized Inverted Index|GIN]]
! [[Full text search|Full-text]]
! [[Spatial index|Spatial]]
! [[Forest of Trees|FOT]]
|}

<cite id="idx_1">[[#idx 1 back|Note (1):]]</cite> The users need to use a function from freeAdhocUDF library or similar.<ref>{{Citation | url = http://www.udf.adhoc-data.de/index_eng.html | publisher = Ad Hoc Data | title = UDF}}</ref>

<cite id="idx_2">[[#idx 2 back|Note (2):]]</cite> Can be implemented for most data types using expression-based indexes.

<cite id="idx_3">[[#idx 3 back|Note (3):]]</cite> Can be emulated by indexing a computed column<ref>{{Citation | series = MSDN | url = http://msdn.microsoft.com/library/default.asp?url=/library/en-us/createdb/cm_8_des_05_8os3.asp | publisher = Microsoft | title = Library | chapter = Create DB}}</ref> (doesn't easily update) or by using an "Indexed View"<ref>{{Citation | series = MSDN | publisher = Microsoft | url = http://msdn.microsoft.com/en-us/library/aa933124(SQL.80).aspx | title = Library | chapter = SQL}}</ref> (proper name not just any view works<ref>{{cite book| last= Petkovic | first=Dusan| title=Microsoft SQL Server 2005: A Beginner’s Guide | publisher=McGraw-Hill Professional|year=2005|isbn= 978-0-07-226093-9 |page=300}}</ref>).

<cite id="idx_4">[[#idx 4 back|Note (4):]]</cite> Can be implemented by using an indexed view.<ref>{{Citation | series = MSDN | url = http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/indexedviews1.asp | title = Library | chapter = Indexed Views}}</ref>

<cite id="idx_5">[[#idx 5 back|Note (5):]]</cite> InnoDB automatically generates adaptive hash index<ref>{{Citation | publisher = Oracle | url = http://dev.mysql.com/doc/refman/5.0/en/innodb-adaptive-hash.html | title = Reference manual | chapter = InnoDB adaptive Hash | number = 5.0 | series = Development documentation}}</ref> entries as needed.

<cite id="idx_6">[[#idx 6 back|Note (6):]]</cite> Can be implemented using Function-based Indexes in Oracle 8i and higher, but the function needs to be used in the sql for the index to be used.

<cite id="idx_7">[[#idx 7 back|Note (7):]]</cite> A PostgreSQL functional index can be used to reverse the order of a field.

<cite id="idx_8">[[#idx 8 back|Note (8):]]</cite> PostgreSQL will likely support on-disk bitmap indexes in a future version.  Version 8.2 supports a related technique known as "in-memory bitmap scans".

<cite id="idx_10">[[#idx 10 back|Note (10):]]</cite> B+ tree and full-text only for now.

<cite id="idx_11">[[#idx 11 back|Note (11):]]</cite> R-Tree indexing available in base edition with Locator but some functionality requires Personal Edition or Enterprise Edition with Spatial option.

==Database capabilities==
{| style="text-align: center; width: 95%" class="wikitable sortable"
|-
! style="width:16em" |
! [[Union (SQL)|Union]]
! [[Intersect (sql)|Intersect]]
! [[Except (SQL)|Except]]
! [[Inner join]]s
! [[Outer join]]s
! Inner selects
! [[Join (SQL)#Merge join|Merge joins]]
! [[Binary large object|Blobs]] and [[Character large object|Clobs]]
! [[Common table expressions|Common Table Expressions]]
! [[Window function (SQL)|Windowing Functions]]
! Parallel Query
|-
! style="text-align:left" | [[4th Dimension (Software)|4th Dimension]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[ADABAS]]
| {{yes}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[Adaptive Server Enterprise]]
| {{yes}}
| {{dunno}}
| {{dunno}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{dunno}}
| {{yes}}
|-
! style="text-align:left" | [[Advantage Database Server]]
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[Altibase]]
| {{yes}}
| {{yes}}
| {{yes|Yes, via MINUS}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{No}}
| {{No}}
| {{No}}
|-
! style="text-align:left" | [[Apache Derby]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{dunno}}
| {{yes}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[Clustrix]]
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[CUBRID]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{yes}}<ref name="CUBRID 9.0 release"/>
| {{dunno}}
|-
! style="text-align:left" | [[Drizzle (database server)|Drizzle]]
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}<ref>[https://answers.launchpad.net/drizzle/+question/135548 How does Drizzle handle parallel "things"?]</ref>
|-
! style="text-align:left" | [[IBM DB2|DB2]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}<ref>{{Citation | url = http://www.ibm.com/developerworks/data/library/techarticle/dm-0608mcinerney/ | publisher = IBM | series = Developer Works | title = Library | chapter = Article}}</ref>
|-
! style="text-align:left" | [[Empress database|Empress Embedded Database]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[EXASOL|EXASolution]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[Firebird (database server)|Firebird]]
| {{yes}}
| {{dunno}}
| {{dunno}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
|-
! style="text-align:left" | [[HSQLDB]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}<ref name="New Features in HyperSQL 2.2">[http://hsqldb.org/web/features200.html New Features in HyperSQL 2.2]</ref>
| {{yes}}
| {{yes}}
| {{no}}
| {{yes}}<ref name="New Features in HyperSQL 2.2"/>
|-
! style="text-align:left" | [[H2 (DBMS)|H2]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{yes}}
| experimental<ref>[http://h2database.com/html/advanced.html#recursive_queries H2 > Advanced > Recursive Queries]</ref>
| {{no}}<ref>[http://www.h2database.com/html/roadmap.html H2 Roadmap]</ref>
| {{dunno}}
|-
! style="text-align:left" | [[Informix Dynamic Server]]
| {{yes}}
| {{yes}}
| {{yes|Yes, via MINUS}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}<ref>[http://portal.acm.org/citation.cfm?id=382443 Informix parallel data query (PDQ)]</ref>
|-
! style="text-align:left" | [[Ingres (database)|Ingres]]
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[InterBase]]
| {{Yes}}
| {{dunno}}
| {{dunno}}
| {{Yes}}
| {{Yes}}
| {{dunno}}
| {{dunno}}
| {{Yes}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[Linter SQL RDBMS]]
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{No}}
|-
! style="text-align:left" | [[LucidDB]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[MaxDB]]
| {{Yes}}
| {{dunno}}
| {{dunno}}
| {{Yes}}
| {{Yes}}
| {{Yes}}
| {{no}}
| {{Yes}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[Microsoft Access]] (JET)
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[Microsoft Visual Foxpro]]
| {{yes}}
| {{dunno}}
| {{dunno}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[Microsoft SQL Server]]
| {{yes}}
| {{yes}} (2005 and beyond)
| {{yes}} (2005 and beyond)
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}<ref>{{Citation | url = http://msdn.microsoft.com/en-US/library/ms189798%28v=sql.105%29 | publisher = Microsoft | title = Only very limited functions available before SQL Server 2012}}</ref>
| {{yes}}<ref>{{Citation | url = http://msdn.microsoft.com/en-us/library/ms178065.aspx | publisher = Microsoft | series = MSDN | title = Library | chapter = SQL Server Parallel Query Processing}}</ref>
|-
! style="text-align:left" | [[SQL Server Compact|Microsoft SQL Server Compact (Embedded Database)]]
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[MonetDB]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[MySQL]]
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}<ref>{{Citation | publisher = Oracle | series = MySQL | url = http://bugs.mysql.com/bug.php?id=16244 | title = Bugs | chapter = Feature request #16244: SQL-99 Derived table WITH clause (CTE)}}</ref>
| {{no}}
| {{no}}<ref>{{Citation | publisher = Oracle | series = MySQL | url = http://bugs.mysql.com/bug.php?id=1542 | title = Bugs | chapter = Feature request #1542: Parallel query}}</ref>
|-
! style="text-align:left" | [[OpenBase|OpenBase SQL]]
| {{no}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[Virtuoso Universal Server|OpenLink Virtuoso]]
| {{yes}}
| {{dunno}}
| {{dunno}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[Oracle Database|Oracle]]
| {{yes}}
| {{yes}}
| {{yes|Yes, via MINUS}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}} <sup id="capa_1_back">[[#capa 1|1]]
| {{yes}}
| {{yes}}<ref>{{Citation | publisher = Ora FAQ | series = Wiki | url = http://www.orafaq.com/wiki/Parallel_Query_FAQ | title = Parallel Query}}</ref>
|-
! style="text-align:left" | [[Oracle Rdb]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[Pervasive PSQL]]
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{dunno}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[Polyhedra DBMS]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{dunno}}
| {{dunno}}
| {{yes}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[PostgreSQL]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}<ref>{{Citation | url = https://wiki.postgresql.org/wiki/Parallel_Query_Execution | publisher = PostgreSQL | title = Parallel Query Execution}}</ref>
|-
! style="text-align:left" | [[RDM Embedded]]
| {{no}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[RDM Server]]
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[ScimoreDB]]
| {{yes}}
| {{dunno}}
| {{dunno}}
| {{yes}}
| {{Depends|LEFT only}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[SmallSQL]]
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[solidDB]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[SQL Anywhere]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[SQLite]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{Depends|LEFT only}}
| {{yes}}
| {{no}}
| {{yes}}
| {{yes|3.8.3+}}<ref>[http://sqlite.org/lang_with.html SQLite Query Language: WITH clause]</ref>
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[Teradata]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[UniVerse]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! |
! [[Union (SQL)|Union]]
! [[Intersect (sql)|Intersect]]
! [[Except (SQL)|Except]]
! [[Inner join]]s
! [[Outer join]]s
! Inner selects
! [[Join (SQL)#Merge join|Merge joins]]
! [[Binary large object|Blobs]] and [[Character large object|Clobs]]
! [[Common table expressions|Common Table Expressions]]
! [[Window function (SQL)|Windowing Functions]]
! Parallel Query
|}

<cite id="capa_1">[[#capa 1 back|Note (1):]]</cite>
Recursive CTEs introduced in 11gR2 supersedes similar construct called CONNECT BY.

==Data types==
{| style="text-align: center; width: 95%l font-size: 96%;" class="wikitable sortable"
|-
! style="width:16em" |
! [[Type system]]
! [[Integer (computer science)|Integer]]
! [[Floating point]]
! Decimal
! [[String (computer science)|String]]
! [[Binary large object|Binary]]
! Date/Time
! [[Boolean data type|Boolean]]
! Other
|-
! style="text-align:left" | [[4th Dimension (Software)|4th Dimension]]
| Static
| UUID (16-bit), SMALLINT (16-bit), INT (32-bit), BIGINT (64-bit), NUMERIC (64-bit)
| REAL, FLOAT
| REAL, FLOAT
| CLOB, TEXT, VARCHAR
| BIT, BIT VARYING, BLOB
| DURATION, INTERVAL, TIMESTAMP
| BOOLEAN
| PICTURE
|-
! style="text-align:left" | [[Altibase]]<ref name="Altibase-datatypes">{{Citation | publisher = Altibase | series = HDB | url = http://atc.altibase.com/sub09/611b/html/GeneralReference/ch01s01s01.html | title = General Reference | chapter = Data Types}}</ref>
| Static
| SMALLINT (16-bit), INTEGER (32-bit), BIGINT (64-bit)
| REAL(32-bit), DOUBLE(64-bit)
| DECIMAL, NUMERIC, NUMBER, FLOAT
| CHAR, VARCHAR, NCHAR, NVARCHAR, CLOB
| BLOB, BYTE, NIBBLE, BIT, VARBIT
| DATE
| 
| GEOMETRY
|-
! style="text-align:left" | [[Clustrix]]<ref name="mysql-datatypes">{{Citation | publisher = Clustrix  | title = System Administrator's Guide | number = 5.0 | url = http://docs.clustrix.com/display/CLXDOC/Data+Types | chapter = Data Types}}</ref>
| Static
| TINYINT (8-bit), SMALLINT (16-bit),  MEDIUMINT (24-bit), INT (32-bit), BIGINT (64-bit)
| FLOAT (32-bit), DOUBLE
| DECIMAL
| CHAR, BINARY, VARCHAR, VARBINARY, TEXT, TINYTEXT, MEDIUMTEXT, LONGTEXT
| TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB
| DATETIME, DATE, TIMESTAMP, YEAR
| BIT(1), BOOLEAN
| ENUM, SET,
|-
! style="text-align:left" | [[CUBRID]]<ref name="CUBRID-datatypes">{{Citation | publisher = CUBRID | series = Reference Manual | url = http://www.cubrid.org/manual/syntax/syntax_datatype_num_def.htm | title = CUBRID SQL Guide | chapter = Data Types}}</ref>
| Static
| SMALLINT (16-bit), INTEGER (32-bit), BIGINT (64-bit)
| FLOAT, REAL(32-bit), DOUBLE(64-bit)
| DECIMAL, NUMERIC
| CHAR, VARCHAR, NCHAR, NVARCHAR, CLOB
| BLOB
| DATE, DATETIME, TIME, TIMESTAMP
| BIT
| MONETARY, BIT VARYING, SET, MULTISET, SEQUENCE, ENUM
|-
! style="text-align:left" | [[Drizzle (database server)|Drizzle]]<ref name="drizzle-datatypes">{{Citation | publisher = Drizzle | series = Documents | url = http://docs.drizzle.org/columntypes.html | title = Built-in Column Types}}</ref>
| Static
| INT (32-bit), BIGINT (64-bit)
| DOUBLE (aka REAL) (64-bit)
| DECIMAL
| BINARY, VARCHAR, VARBINARY, TEXT,
| BLOB
| DATETIME, DATE, TIMESTAMP
|
| ENUM, SERIAL
|-
! style="text-align:left" | [[Empress database|Empress Embedded Database]]
| Static
| TINYINT, SQL_TINYINT, or INTEGER8; SMALLINT, SQL_SMALLINT, or INTEGER16; INTEGER, INT, SQL_INTEGER, or INTEGER32; BIGINT, SQL_BIGINT, or INTEGER64
| REAL, SQL_REAL, or FLOAT32; DOUBLE PRECISION, SQL_DOUBLE, or FLOAT64; FLOAT, or SQL_FLOAT; EFLOAT
| DECIMAL, DEC, NUMERIC, SQL_DECIMAL, or SQL_NUMERIC; DOLLAR
| CHARACTER, ECHARACTER, CHARACTER VARYING, NATIONAL CHARACTER, NATIONAL CHARACTER VARYING, NLSCHARACTER, CHARACTER LARGE OBJECT, TEXT, NATIONAL CHARACTER LARGE OBJECT, NLSTEXT
| BINARY LARGE OBJECT or BLOB; BULK
| DATE, EDATE, TIME, ETIME, EPOCH_TIME, TIMESTAMP, MICROTIMESTAMP
| BOOLEAN
| SEQUENCE 32, SEQUENCE
|-
! style="text-align:left" | [[EXASOL|EXASolution]]
| Static
| TINYINT, SMALLINT, INTEGER, BIGINT,
| REAL, FLOAT, DOUBLE
| DECIMAL, DEC, NUMERIC, NUMBER
| CHAR, NCHAR,  VARCHAR, VARCHAR2, NVARCHAR, NVARCHAR2, CLOB, NCLOB
| N/A
| DATE, TIMESTAMP, INTERVAL
| BOOLEAN, BOOL
| GEOMETRY
|-
! style="text-align:left" | [[HSQLDB]]<ref name="hsqldb-datatypes">{{Citation | publisher = HSQLDB | series = Documents | number = 2.0 | title = Guide | url=http://hsqldb.org/doc/2.0/guide/sqlgeneral-chapt.html#sqlgeneral_types_ops-sect | chapter = General: HSQLDB data types}}</ref>
| Static
| TINYINT (8-bit), SMALLINT (16-bit), INTEGER (32-bit), BIGINT (64-bit)
| DOUBLE (64-bit)
| DECIMAL, NUMERIC
| CHAR, VARCHAR, LONGVARCHAR, CLOB
| BINARY, VARBINARY, LONGVARBINARY, BLOB
| DATE, TIME, TIMESTAMP, INTERVAL
| BOOLEAN
| OTHER (object), BIT, BIT VARYING, ARRAY
|-
! style="text-align:left" | [[Informix Dynamic Server]]<ref name="informix-datatypes">{{cite web |publisher=IBM |series=Publications |url=http://www-05.ibm.com/e-business/linkweb/publications/servlet/pbi.wss?CTY=US&FNC=SRX&PBL=SC23-7750-04 |title=IBM Informix Guide to SQL: Reference, v11.50 (SC23-7750-04) |deadurl=no |accessdate=August 7, 2013}}</ref>
| Static
| SMALLINT (16-bit), INT (32-bit), INT8 (64-bit proprietary), BIGINT (64-bit)
| SMALLFLOAT (32-bit), FLOAT (64-bit)
| DECIMAL (32 digits float/fixed), MONEY
| CHAR, VARCHAR, NCHAR, NVARCHAR, LVARCHAR, CLOB, TEXT
| TEXT, BYTE, BLOB, CLOB
| DATE, DATETIME, INTERVAL
| BOOLEAN
| SET, LIST, MULTISET, ROW, TIMESERIES, SPATIAL, JSON, BSON, USER DEFINED TYPES
|-
! style="text-align:left" | [[Ingres (database)|Ingres]]<ref name="ingres-datatypes">{{Citation | publisher = Ingres | series = Doucments | number = 9.3 | url = http://docs.ingres.com/Ingres/9.3/SQL%20Reference%20Guide/understandingsqldatatypes.htm#o3623 | title = SQL Reference Guide | chapter = 3: Understanding SQL Data Types}}</ref>
| Static
| TINYINT (8-bit), SMALLINT (16-bit), INTEGER (32-bit), BIGINT (64-bit)
| FLOAT4 (32-bit), FLOAT (64-bit)
| DECIMAL
| C, CHAR, VARCHAR, LONG VARCHAR, NCHAR, NVARCHAR, LONG NVARCHAR, TEXT
| BYTE, VARBYTE, LONG VARBYTE (BLOB)
| DATE, ANSIDATE, INGRESDATE, TIME, TIMESTAMP, INTERVAL
| N/A
| MONEY, OBJECT_KEY, TABLE_KEY, USER-DEFINED DATA TYPES (via OME)
|-
! style="text-align:left" | [[Linter SQL RDBMS]]
| Static
| SMALLINT (16-bit), INTEGER (32-bit), BIGINT (64-bit)
| REAL(32-bit), DOUBLE(64-bit)
| DECIMAL, NUMERIC
| CHAR, VARCHAR, NCHAR, NVARCHAR, BLOB
| BYTE, VARBYTE, BLOB
| DATE
| BOOLEAN
| GEOMETRY, EXTFILE
|-
! style="text-align:left" | [[Microsoft SQL Server]]<ref name="sql-server-datatypes">{{Citation | publisher = Microsoft | series = MSDN | title = Library | url = http://msdn.microsoft.com/en-us/library/ms187752.aspx | chapter = SQL Server Data Types}}</ref>
| Static
| TINYINT, SMALLINT, INT, BIGINT
| FLOAT, REAL
| NUMERIC, DECIMAL, SMALLMONEY, MONEY
| CHAR, VARCHAR, TEXT, NCHAR, NVARCHAR, NTEXT
| BINARY, VARBINARY, IMAGE, FILESTREAM
| DATE, DATETIMEOFFSET, DATETIME2, SMALLDATETIME, DATETIME, TIME
| BIT
| CURSOR, TIMESTAMP, HIERARCHYID, UNIQUEIDENTIFIER, SQL_VARIANT, XML, TABLE, Geometry, Geography
|-
! style="text-align:left" | [[SQL Server Compact|Microsoft SQL Server Compact (Embedded Database)]]<ref name="sqlce-datatypes">{{Citation | publisher = Microsoft | series = MSDN | title = Library | url = http://msdn.microsoft.com/en-us/library/ms172424.aspx | chapter = SQL Server Compact Data Types}}</ref>
| Static
| TINYINT, SMALLINT, INT, BIGINT
| FLOAT, REAL
| NUMERIC, DECIMAL, MONEY
| NCHAR, NVARCHAR, NTEXT
| BINARY, VARBINARY, IMAGE
| DATETIME
| BIT
| TIMESTAMP, ROWVERSION, UNIQUEIDENTIFIER, IDENTITY, ROWGUIDCOL
|-
! style="text-align:left" | [[MonetDB]]
| Static
| TINYINT, SMALLINT, INT, BIGINT
| FLOAT, REAL, DOUBLE
| NUMERIC, DECIMAL
| VARCHAR(n),CHAR(n),CLOB
| BLOB
| DATE, TIME, DATETIME, TIMESTAMP
| BIT
| TIME WITH TIME ZONE TIMESTAMP WITH TIME ZONE, DAY, MONTH, YEAR, INTERVAL
|-
! style="text-align:left" | [[MySQL]]<ref name="mysql-datatypes">{{Citation | publisher = Oracle | series = MySQL | title = Reference manual | number = 5.0 | url = http://dev.mysql.com/doc/refman/5.0/en/data-types.html | chapter = 10. Data Types}}</ref>
| Static
| TINYINT (8-bit), SMALLINT (16-bit),  MEDIUMINT (24-bit), INT (32-bit), BIGINT (64-bit)
| FLOAT (32-bit), DOUBLE (aka REAL) (64-bit)
| DECIMAL
| CHAR, BINARY, VARCHAR, VARBINARY, TEXT, TINYTEXT, MEDIUMTEXT, LONGTEXT
| TINYBLOB, BLOB, MEDIUMBLOB, LONGBLOB
| DATETIME, DATE, TIMESTAMP, YEAR
| BIT(1), BOOLEAN (aka BOOL) = synonym for TINYINT
| ENUM, SET, GIS data types (Geometry, Point, Curve, LineString, Surface, Polygon, GeometryCollection, MultiPoint, MultiCurve, MultiLineString, MultiSurface, MultiPolygon)
|-
! style="text-align:left" | [[Virtuoso Universal Server|OpenLink Virtuoso]]<ref name="Virtuoso-datatypes">{{Citation | publisher = OpenLink Software | url = http://docs.openlinksw.com/virtuoso/sqlrefDATATYPES.html | title = SQL Reference | chapter = Datatypes}}</ref>
| Static + Dynamic
| INT, INTEGER, SMALLINT
| REAL, DOUBLE PRECISION, FLOAT, FLOAT'('INTNUM')'
| DECIMAL, DECIMAL'('INTNUM')', DECIMAL'('INTNUM','INTNUM')', NUMERIC, NUMERIC'('INTNUM')', NUMERIC'('INTNUM','INTNUM')'
| CHARACTER, CHAR'('INTNUM')', VARCHAR, VARCHAR'('INTNUM')', NVARCHAR, NVARCHAR'('INTNUM')'
| BLOB
| TIMESTAMP, DATETIME, TIME, DATE
| n/a
| GEOMETRY, REFERENCE (URI), UDT (User Defined Type)
|-
! style="text-align:left" | [[Oracle Database|Oracle]]<ref name="oracle-datatypes">{{Citation | publisher = Oracle | series = Server documents | title = SQL Reference | number = 11.2 | url = http://download.oracle.com/docs/cd/E11882_01/server.112/e10592/sql_elements001.htm#i45441 | chapter = Data Types}}</ref>
| Static + Dynamic (through ANYDATA)
| NUMBER
| BINARY_FLOAT, BINARY_DOUBLE
| NUMBER
| CHAR, VARCHAR2, CLOB, NCLOB, NVARCHAR2, NCHAR, LONG (deprecated)
| BLOB, RAW, LONG RAW (deprecated), BFILE
| DATE, TIMESTAMP (with/without TIMEZONE), INTERVAL
| N/A
| SPATIAL, IMAGE, AUDIO, VIDEO, DICOM, XMLType
|-
! style="text-align:left" | [[Pervasive PSQL]]<ref name="psql-datatypes">{{Citation | publisher = Pervasive | series = Product documentation | url = http://docs.pervasive.com/products/database/psqlv11/wwhelp/wwhimpl/js/html/wwhelp.htm#href=sqlref/SQLDtype.10.1.html#134765 | title = Pervasive PSQL Supported Data Types | chapter = Data Types}}</ref>
| Static
| BIGINT, INTEGER, SMALLINT, TINYINT, UBIGINT, UINTEGER, USMALLINT, UTINYINT
| BFLOAT4, BFLOAT8, DOUBLE, FLOAT
| DECIMAL, NUMERIC, NUMERICSA, NUMERICSLB, NUMERICSLS, NUMERICSTB, NUMERICSTS
| CHAR, LONGVARCHAR, VARCHAR
| BINARY, LONGVARBINARY, VARBINARY
| DATE, DATETIME, TIME
| BIT
| CURRENCY, IDENTITY, SMALLIDENTITY, TIMESTAMP, UNIQUEIDENTIFIER
|-
! style="text-align:left" | [[Polyhedra DBMS|Polyhedra]]<ref>{{Citation | publisher = Enea AB| series = Product documentation | url = http://developer.polyhedra.com/manuals/rtrdb-reference-manual/sql-reference-manual | title = Polyhedra SQL Reference Manual }}</ref>
| Static
| INTEGER8 (8-bit), INTEGER(16-bit), INTEGER (32-bit), INTEGER64 (64-bit)
| FLOAT32 (32-bit), FLOAT (aka REAL; 64-bit)
| N/A
| VARCHAR, LARGE VARCHAR (aka CHARACTER LARGE OBJECT)
| LARGE BINARY (aka BINARY LARGE OBJECT)
| DATETIME
| BOOLEAN
| N/A
|-
! style="text-align:left" | [[PostgreSQL]]<ref name="postgresql-datatypes">{{Citation | publisher = PostgreSQL community | series = Documents | number = 8.4 | url = http://www.postgresql.org/docs/8.4/interactive/datatype.html | title = Manual | chapter = Data Types}}</ref>
| Static
| SMALLINT (16-bit), INTEGER (32-bit), BIGINT (64-bit)
| REAL (32-bit), DOUBLE PRECISION (64-bit)
| DECIMAL, NUMERIC
| CHAR, VARCHAR, TEXT
| BYTEA
| DATE, TIME (with/without TIMEZONE), TIMESTAMP (with/without TIMEZONE), INTERVAL
| BOOLEAN
| ENUM, POINT, LINE, LSEG, BOX, PATH, POLYGON, CIRCLE, CIDR, INET, MACADDR, BIT, UUID, XML, JSON, arrays, composites, ranges, custom
|-
! style="text-align:left" | [[RDM Embedded]]<ref>{{Citation | publisher = Raima | title = SQL Reference | number = 10.1 | url = http://docs.raima.com/rdme/10_1/Content/SQL/Chapter4.htm#Create_Domain | chapter = Defining a Database}}</ref>
| Static
| tinyint, smallint, integer, bigint
| real, float, double
| N/A
| char, varchar, wchar, varwchar, long varchar, long varwchar
| binary, varbinary, long varbinary
| date, time, timestamp
| bit
| N/A
|-
! style="text-align:left" | [[RDM Server]]<ref>{{Citation | publisher = Raima | title = SQL Reference | number = 8.3 | url = http://docs.raima.com/rdms/8_3/Content/UG/Chapter6.htm#6.3.3.3_Define_Table_Columns | chapter = Defining Table Columns}}</ref>
| Static
| tinyint, smallint, integer, bigint
| real, float, double
| decimal, numeric
| char, varchar, wchar, varwchar, long varchar, long varwchar
| binary, varbinary, long varbinary
| date, time, timestamp
| bit
| rowid
|-
! style="text-align:left" | [[solidDB]]
| Static
| TINYINT (8-bit), SMALLINT (16-bit), INTEGER (32-bit), BIGINT (64-bit)
| REAL (32-bit), DOUBLE (64-bit), FLOAT (64-bit)
| DECIMAL, NUMERIC (51 digits)
| CHAR, VARCHAR, LONG VARCHAR, WCHAR, WVARCHAR, LONG WVARCHAR
| BINARY, VARBINARY, LONG VARBINARY
| DATE, TIME, TIMESTAMP
| 
| 
|-
! style="text-align:left" | [[SQLite]]<ref name="sqlite-datatypes">{{Citation | url = http://www.sqlite.org/datatype3.html | publisher = SQLite | title = Datatypes | number = 3}}</ref>
| Dynamic
| INTEGER (64-bit)
| REAL (aka FLOAT, DOUBLE) (64-bit)
| N/A
| TEXT (aka CHAR, CLOB)
| BLOB
| N/A
| N/A
| N/A
|-
! style="text-align:left" | [[UniData]]
| Dynamic
| N/A
| N/A
| N/A
| N/A
| N/A
| N/A
| N/A
| N/A
|-
! style="text-align:left" | [[UniVerse]]
| Dynamic
| N/A
| N/A
| N/A
| N/A
| N/A
| N/A
| N/A
| N/A
|-
! |
! [[Type system]]
! [[Integer (computer science)|Integer]]
! [[Floating point]]
! Decimal
! [[String (computer science)|String]]
! [[Binary large object|Binary]]
! Date/Time
! [[Boolean data type|Boolean]]
! Other
|}

==Other objects==
Information about what other objects are supported natively.
{| style="text-align: center; width: 95%" class="wikitable sortable"
|-
! style="width:16em" |
! [[Data Domain]]
! [[Cursor (databases)|Cursor]]
! [[Database trigger|Trigger]]
! [[Function (programming)|Function]]&nbsp;<sup id="other_1_back">[[#other 1|1]]</sup>
! [[Subroutine|Procedure]]&nbsp;<sup>[[#other 1|1]]</sup>
! External routine&nbsp;<sup>[[#other 1|1]]</sup>
|-
! style="text-align:left" | [[4th Dimension (Software)|4th Dimension]]
| {{yes}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[ADABAS]]
| {{dunno}}
| {{yes}}
| {{dunno}}
| {{yes}}?
| {{yes}}?
| {{yes}}
|-
! style="text-align:left" | [[Adaptive Server Enterprise]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[Advantage Database Server]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[Altibase]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[Apache Derby]]
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}&nbsp;<sup id="other_2_back">[[#other 2|2]]</sup>
| {{yes}}&nbsp;<sup>[[#other 2|2]]</sup>
| {{yes}}&nbsp;<sup>[[#other 2|2]]</sup>
|-
! style="text-align:left" | [[Clustrix]]
| {{no}}
| {{yes}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[CUBRID]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}&nbsp;<sup>[[#other 2|2]]</sup>
| {{yes}}
|-
! style="text-align:left" | [[Drizzle (database server)|Drizzle]]
| {{yes}}
| {{yes}}
| {{yes}}&nbsp;<sup>[[#other 4|4]]</sup>
| {{yes}}&nbsp;<sup>[[#other 4|4]]</sup>
| {{yes}}&nbsp;<sup>[[#other 4|4]]</sup>
| {{yes}}&nbsp;<sup>[[#other 4|4]]</sup>
|-
! style="text-align:left" | [[Empress database|Empress Embedded Database]]
| {{yes}} via RANGE CHECK
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[EXASOL|EXASolution]]
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[IBM DB2|DB2]]
| {{yes}} via CHECK CONSTRAINT
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[Firebird (database server)|Firebird]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[HSQLDB]]
| {{yes}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[H2 (DBMS)|H2]]
| {{yes}}
| {{no}}
| {{yes}}&nbsp;<sup>[[#other 2|2]]</sup>
| {{yes}}&nbsp;<sup>[[#other 2|2]]</sup>
| {{yes}}&nbsp;<sup>[[#other 2|2]]</sup>
| {{yes}}
|-
! style="text-align:left" | [[Informix Dynamic Server]]
| {{yes}} via CHECK
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}} &nbsp;<sup>[[#other 5|5]]</sup>
|-
! style="text-align:left" | [[Ingres (database)|Ingres]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[InterBase]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[Linter SQL RDBMS]]
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
|-
! style="text-align:left" | [[LucidDB]]
| {{no}}
| {{yes}}
| {{no}}
| {{yes}}&nbsp;<sup>[[#other 2|2]]</sup>
| {{yes}}&nbsp;<sup>[[#other 2|2]]</sup>
| {{yes}}&nbsp;<sup>[[#other 2|2]]</sup>
|-
! style="text-align:left" | [[MaxDB]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
|-
! style="text-align:left" | [[Microsoft Access]] (JET)
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{Depends|Yes, But single DML/DDL Operation}}
| {{yes}}
|-
! style="text-align:left" | [[Microsoft Visual Foxpro]]
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[Microsoft SQL Server]]
| {{yes}} (2000 and beyond)
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[SQL Server Compact|Microsoft SQL Server Compact (Embedded Database)]]
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[MonetDB]]
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[MySQL]]
| {{no}} &nbsp;<sup>[[#other 3|3]]</sup>
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[OpenBase|OpenBase SQL]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[Oracle Database|Oracle]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[Oracle Rdb]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[Virtuoso Universal Server|OpenLink Virtuoso]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[Pervasive PSQL]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
|-
! style="text-align:left" | [[Polyhedra DBMS]]
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[PostgreSQL]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[RDM Embedded]]
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[RDM Server]]
| {{no}}
| {{yes}}
| {{yes}}
| {{no}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[ScimoreDB]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[solidDB]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[SQL Anywhere]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[SQLite]]
| {{no}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
|-
! style="text-align:left" | [[Teradata]]
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[UniData]]
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[UniVerse]]
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! |
! [[Data Domain]]
! [[Cursor (databases)|Cursor]]
! [[Database trigger|Trigger]]
! [[Function (programming)|Function]]&nbsp;<sup id="other_1_back">[[#other 1|1]]</sup>
! [[Subroutine|Procedure]]&nbsp;<sup>[[#other 1|1]]</sup>
! External routine&nbsp;<sup>[[#other 1|1]]</sup>
|}

<cite id="other_1">[[#other 1 back|Note (1):]]</cite> Both '''function''' and '''procedure''' refer to internal routines written in SQL and/or procedural language like [[PL/SQL]]. '''External routine''' refers to the one written in the host languages, such as C, Java, Cobol, etc. "[[Stored procedure]]" is a commonly used term for these routine types. However, its definition varies between different database vendors.

<cite id="other_2">[[#other 2 back|Note (2):]]</cite> In Derby, H2, LucidDB, and CUBRID, users code '''functions''' and '''procedures''' in Java.

<cite id="other_3">[[#other 3 back|Note (3):]]</cite> ENUM datatype exist. CHECK clause is parsed, but not enforced in runtime.

<cite id="other_4">[[#other 4 back|Note (4):]]</cite> In Drizzle the user codes '''functions''' and '''procedures''' in C++.

<cite id="other_5">[[#other 5 back|Note (5):]]</cite> Informix supports external functions written in Java, C, & C++.

==Partitioning==
Information about what [[partition (database)|partitioning]] methods are supported natively.
{| style="text-align: center; width: 95%" class="wikitable sortable"
|-
! style="width:16em" |
! Range
! Hash
! Composite (Range+Hash)
! List
! Expression
|-
! style="text-align:left" | [[4th Dimension (Software)|4th Dimension]]
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[ADABAS]]
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[Adaptive Server Enterprise]]
| {{yes}}
| {{yes}}
| {{no}}
| {{yes}}
| {{dunno}}
|-
! style="text-align:left" | [[Advantage Database Server]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[Altibase]]
| {{yes}}
| {{yes}}
| {{no}}
| {{yes}}
| {{dunno}}
|-
! style="text-align:left" | [[Apache Derby]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[Clustrix]]
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[CUBRID]]
| {{yes}}
| {{yes}}
| {{no}}
| {{yes}}
| {{dunno}}
|-
! style="text-align:left" | [[IBM DB2]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
|-
! style="text-align:left" | [[Empress database|Empress Embedded Database]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[EXASOL|EXASolution]]
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[Firebird (database server)|Firebird]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[HSQLDB]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[H2 (DBMS)|H2]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[Informix Dynamic Server]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[Ingres (database)|Ingres]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
|-
! style="text-align:left" | [[InterBase]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[Linter SQL RDBMS]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[MaxDB]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[Microsoft Access]] (JET)
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[Microsoft Visual Foxpro]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[Microsoft SQL Server]]
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[SQL Server Compact|Microsoft SQL Server Compact (Embedded Database)]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[MonetDB]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[MySQL]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
|-
! style="text-align:left" | [[OpenBase|OpenBase SQL]]
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[Oracle Database|Oracle]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
|-
! style="text-align:left" | [[Oracle Rdb]]
| {{yes}}
| {{yes}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[Virtuoso Universal Server|OpenLink Virtuoso]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[Pervasive PSQL]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[Polyhedra DBMS]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[PostgreSQL]]
| {{yes}}<sup id="part_1_back">[[#part 1|1]]</sup>
| {{yes}}<sup>[[#part 1|1]]</sup>
| {{yes}}<sup>[[#part 1|1]]</sup>
| {{yes}}<sup>[[#part 1|1]]</sup>
| {{dunno}}
|-
! style="text-align:left" | [[RDM Embedded]]
| {{yes}}<sup id="raima_2_back">[[#raima 2|2]]</sup>
| {{yes}}<sup>[[#raima 2|2]]</sup>
| {{yes}}<sup>[[#raima 2|2]]</sup>
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[RDM Server]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[ScimoreDB]]
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[solidDB]]
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[SQL Anywhere]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[SQLite]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[Teradata]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
|-
! style="text-align:left" | [[UniVerse]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
|-
! |
! Range
! Hash
! Composite (Range+Hash)
! List
! Expression
|}

<cite id="part_1">[[#part 1 back|Note (1):]]</cite> PostgreSQL 8.1 provides partitioning support through check constraints. Range, List and Hash methods can be emulated with [[PL/pgSQL]] or other procedural languages.<ref>{{Citation | publisher = PostgreSQL community | url = http://developer.postgresql.org/docs/postgres/release.html#RELEASE-8-1 | series = Developer | title = Documents | chapter = Release | number = 8.1}}</ref>

<cite id="raima_2">[[#raima 2 back|Note (2):]]</cite> RDM Embedded 10.1 requires the application programs to select the correct partition (using range, hash or composite techniques) when adding data, but the ''database union'' functionality allows all partitions to be read as a single database.<ref>{{Citation | publisher = Raima | url = http://docs.raima.com/rdme/10_1/Content/UG/Chapter5.htm#5.11_Database_Unions | title = User's Guide | chapter = 5.11 Database Unions | number = 10.1}}</ref>

==Access control==
Information about access control functionalities (''work in progress'').
{| style="text-align: center; width: 95%" class="wikitable sortable"
|-
! style="width:16em" |
! Native network encryption<sup>[[#ac 1|1]]</sup>
! Brute-force protection
! Enterprise directory compatibility
! Password complexity rules<sup>[[#ac 2|2]]</sup>
! Patch access<sup>[[#ac 3|3]]</sup>
! Run unprivileged<sup>[[#ac 4|4]]</sup>
! Audit
! Resource limit
! Separation of duties ([[Role-based access control|RBAC]])<sup>[[#ac 5|5]]</sup>
! Security Certification
! Label Based Access Control (LBAC)
|-
! style="text-align:left" | [[4th Dimension (software)|4D]]
| {{yes}} (with SSL)
| {{dunno}}
| {{yes}}
| {{dunno}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[Adaptive Server Enterprise]]
| {{yes}} (optional; to pay)
| {{yes}}
| {{yes}} (optional ?)
| {{yes}}
| {{partial}} (need to register; depend on which product)<ref>{{Citation | publisher = Sybase | series = Downloads | title = Support | url =  http://downloads.sybase.com/swd/base.do?client=support}}</ref>
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}} (EAL4+&nbsp;<sup>[[#ac 1|1]]</sup>)
| {{dunno}}
|-
! style="text-align:left" | [[Advantage Database Server]]
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[IBM DB2|DB2]]
| {{yes}}
| {{dunno}}
| {{yes}} (LDAP, Kerberos…)
| {{yes}}
| {{dunno}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}} (EAL4+<sup id="ac_6_back">[[#ac 6|6]]</sup>)
| {{dunno}}
|-
! style="text-align:left" | [[Empress database|Empress Embedded Database]]
| {{dunno}}
| {{dunno}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[EXASOL|EXASolution]]
| {{no}}
| {{no}}
| {{yes}} (LDAP)
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[Firebird (database server)|Firebird]]
| {{no}}
| {{yes}}<ref>{{Citation | url = http://www.firebirdsql.org/index.php?op=devel&sub=engine&id=fb20_release | publisher = Firebird SQL | series = Development | title = Engine | number = 2.0 | chapter = Release}}</ref>
| {{yes}} (Windows trusted authenification)
| {{no}}
| {{partial}} (no security page)<ref>{{Citation | url = http://www.firebirdsql.org/index.php?op=files | publisher = Firebird SQL | title = Files}}</ref>
| {{yes}}
| {{no}}
| {{no}}
| {{no}}<sup id="ac_7_back">[[#ac 7|7]]</sup>
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[HSQLDB]]
| {{yes}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{yes}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[H2 (DBMS)|H2]]
| {{yes}}
| {{yes}}
| {{dunno}}
| {{no}}
| {{dunno}}
| {{yes}}
| {{dunno}}
| {{yes}}
| {{yes}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[Informix Dynamic Server]]
| {{yes}}
| {{dunno}}
| {{yes}}<sup id="ac_10_back">[[#ac 10|10]]</sup>
| {{dunno}}<sup id="ac_10_back">[[#ac 10|10]]</sup>
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
|-
! style="text-align:left" | [[Linter SQL RDBMS]]
| {{yes}} (with SSL)
| {{yes}}
| {{yes}}
| {{yes}} (length only)
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
|-
! style="text-align:left" | [[MariaDB]]
| {{yes}} (SSL)
| {{no}}
| {{yes}} (with 5.2, but not on Windows servers)
| {{no}}
| {{partial}} (no security page)
| {{yes}}
| {{dunno}}
| {{dunno}}
| {{dunno}}<sup id="ac_8_back">[[#ac 8|8]]</sup>
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[Microsoft SQL Server]]
| {{yes}}
| {{dunno}}
| {{yes}} (Microsoft Active Directory)
| {{yes}}
| {{yes}}
| {{yes}}
| {{Yes}} (From 2008)
| {{Yes}}
| {{Yes}}
| {{yes}} (EAL4+<sup>[[#ac 11|11]]</sup>)
| {{dunno}}
|-
! style="text-align:left" | [[SQL Server Compact|Microsoft SQL Server Compact (Embedded Database)]]
| {{no}} (not relevant, only file permissions)
| {{no}} (not relevant)
| {{no}} (not relevant)
| {{no}} (not relevant)
| {{yes}}
| {{yes}} (file access)
| {{yes}}
| {{yes}}
| {{no}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[MySQL]]
| {{yes}} (SSL with 4.0)
| {{no}}
| {{yes}} (with 5.5, but only in commercial edition)
| {{no}}
| {{partial}} (no security page)<ref>{{Citation | publisher = Oracle | series = MySQL | title = Development | chapter = Downloads | url = http://dev.mysql.com/downloads/}}</ref>
| {{yes}}
| {{dunno}}
| {{dunno}}
| {{dunno}}<sup id="ac_8_back">[[#ac 8|8]]</sup>
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[OpenBase|OpenBase SQL]]
| {{yes}}
| {{dunno}}
| {{yes}} (Open Directory, LDAP)
| {{no}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
| {{dunno}}
|-
! style="text-align:left" | [[OpenLink Virtuoso]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}} (optional)
| {{yes}} (optional)
| {{yes}}
| {{yes}} (optional)
| {{yes}} (optional)
| {{yes}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[Oracle Database|Oracle]]
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{dunno}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}}
| {{yes}} (EAL4+<sup>[[#ac 1|1]]</sup>)
| {{dunno}}
|-
! style="text-align:left" | [[Pervasive PSQL]]
| {{yes}}
| {{dunno}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}} <sup id="ac_12_back">[[#ac 12|12]]</sup>
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[Polyhedra DBMS]]
| {{yes}}  (with SSL. Optional)
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}} <sup id="ac_13_back">[[#ac 13|13]]</sup>
| {{yes}}
| {{yes}} <sup>[[#ac 13|13]]</sup>
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[PostgreSQL]]
| {{yes}}
| {{yes}} (for 9.1)
| {{yes}} (LDAP, Kerberos…<sup id="ac_9_back">[[#ac 9|9]]</sup>)
| {{yes}} (as of 9.0 with passwordcheck module)
| {{yes}}<ref>{{Citation | url = http://www.postgresql.org/support/security.html | publisher = PostgreSQL community | series = Support | title = Security}}</ref>
| {{yes}}
| {{no}}
| {{yes}}
| {{yes}}
| {{yes}} (EAL1<sup>[[#ac 1|1]]</sup>)
| {{dunno}}
|-
! style="text-align:left" | [[RDM Embedded]]
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[RDM Server]]
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
| {{yes}}
| {{yes}}
| {{no}}
| {{yes}}
| {{no}}
| {{dunno}}
|-
! style="text-align:left" | [[solidDB]]
| {{no}}
| {{no}}
| {{yes}}
| {{no}}
| {{no}} 
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{no}}
| {{no}}
|-
! style="text-align:left" | [[SQL Anywhere]]
| {{yes}}
| {{dunno}}
| {{yes}} (Kerberos)
| {{yes}}
| {{dunno}}
| {{yes}}
| {{yes}}
| {{no}}
| {{yes}}
| {{yes}} (EAL3+<sup>[[#ac 1|1]]</sup> as Adaptive Server Anywhere)
| {{dunno}}
|-
! style="text-align:left" | [[SQLite]]
| {{no}} (not relevant, only file permissions)
| {{no}} (not relevant)
| {{no}} (not relevant)
| {{no}} (not relevant)
| {{partial}} (no security page)<ref>{{Citation | url = http://www.sqlite.org/download.html | publisher = SQLite | title = Download}}</ref>
| {{yes}} (file access)
| {{yes}}
| {{yes}}
| {{no}}
| {{no}}
| {{dunno}}
|-
!
! Native network encryption<sup>[[#ac 1|1]]</sup>
! Brute-force protection
! Enterprise directory compatibility
! Password complexity rules<sup>[[#ac 2|2]]</sup>
! Patch access<sup>[[#ac 3|3]]</sup>
! Run unprivileged<sup>[[#ac 4|4]]</sup>
! Audit
! Resource limit
! Separation of duties ([[Role-based access control|RBAC]])<sup>[[#ac 5|5]]</sup>
! Security Certification
! Label Based Access Control (LBAC)
|}

<cite id="ac_1">[[Comparison of relational database management systems#ac 1|Note (1):]]</cite> Network traffic could be transmitted in a secure way (not clear-text, in general SSL encryption).  Precise if option is default, included option or an extra modules to buy.

<cite id="ac_2">[[Comparison of relational database management systems#ac 2|Note (2):]]</cite> Options are present to set a minimum size for password, respect complexity like presence of numbers or special characters.

<cite id="ac_3">[[Comparison of relational database management systems#ac 3|Note (3):]]</cite> How do you get security updates? Is it free access, do you need a login or to pay? Is there easy access through a Web/FTP portal or RSS feed or only through offline access (mail CD-ROM, phone).

<cite id="ac_4">[[Comparison of relational database management systems#ac 4|Note (4):]]</cite> Does database process run as root/administrator or unprivileged user? What is default configuration?

<cite id="ac_5">[[Comparison of relational database management systems#ac 5|Note (5):]]</cite> Is there a separate user to manage special operation like backup (only dump/restore permissions), security officer (audit), administrator (add user/create database), etc.? Is it default or optional?

<cite id="ac_6">[[#ac 6 back|Note (6):]]</cite> Common Criteria certified product list.<ref>{{Citation | publisher = Common Criteria Portal | url = http://www.commoncriteriaportal.org/products_DB.html#DB | series = Products | title = DB}}</ref>

<cite id="ac_7">[[#ac 7 back|Note (7):]]</cite> FirebirdSQL seems to only have SYSDBA user and DB owner. There are no separate roles for backup operator and security administrator.

<cite id="ac_8">[[#ac 8 back|Note (8):]]</cite> User can define a dedicated backup user but nothing particular in default install.<ref>{{Citation | url = http://gentoo-wiki.com/HOWTO_Backup_MySQL | publisher = Gentoo wiki | series = How to | title = Backup MySQL}}</ref>

<cite id="ac_9">[[#ac 9 back|Note (9):]]</cite> Authentication methods.<ref>{{Citation | url = http://www.postgresql.org/docs/8.4/interactive/auth-methods.html | publisher = PostgreSQL community | series = Documents | number = 8.1 | title = Authentication methods}}</ref>

<cite id="ac_10">[[#ac 10 back|Note (10):]]</cite> Informix Dynamic Server supports PAM and other configurable authentication.  By default uses OS authentication.

<cite id="ac_11">[[#ac 11 back|Note (11):]]</cite> Authentication methods.<ref>{{Citation | url = http://www.microsoft.com/en-us/sqlserver/common-criteria.aspx#tab6 | publisher = Microsoft  | title = Common Criteria (CC, ISO15408) }}</ref>

<cite id="ac_12">[[#ac 12 back|Note (12):]]</cite> With the use of Pervasive AuditMaster.

<cite id="ac_13">[[#ac 13 back|Note (13):]]</cite> User-based security is optional in Polyhedra, but when enabled can be enhanced to a role-based model with auditing.<ref name="Polyhedra-audit">{{Citation | url = http://developer.polyhedra.com/how-to-guides/auditing | publisher = Enea AB | series = White Paper | title = Adding audit trails to a Polyhedra IMDB database }}</ref>

==Databases vs schemas (terminology)==
{{Original research|section|date=June 2010}}
The [[SQL]] specification makes clear what an "SQL schema" is; however, different databases implement it incorrectly. To compound this confusion the functionality can, when incorrectly implemented, overlap with that of the parent-database. An SQL schema is simply a [[namespace]] within a database, things within this namespace are addressed using the member [[operator (programming)|operator]] dot "<code>.</code>". This seems to be a universal amongst all of the implementations.

A true [[fully qualified name|fully (database, schema, and table) qualified]] query is exemplified as such: <code>SELECT * FROM database.schema.table</code>

Now, the issue, both a schema and a database can be used to isolate one table, "foo" from another like named table "foo". The following is pseudo code:

* <code>SELECT * FROM db1.foo</code> vs. <code>SELECT * FROM db2.foo</code> (no explicit schema between db and table)
* <code>SELECT * FROM [db1.]default.foo</code> vs. <code>SELECT * FROM [db1.]alternate.foo</code> (no explicit db prefix)

The problem that arises is that former [[MySQL]] users will create multiple databases for one project. In this context, MySQL databases are analogous in function to Postgres-schemas, insomuch as Postgres lacks off-the-shelf cross-database functionality that MySQL has.  Conversely, [[PostgreSQL]] has applied more of the specification implementing cross-table, cross-schema, and then left room for future cross-database functionality.

MySQL aliases ''schema'' with ''database'' behind the scenes, such that <code>CREATE SCHEMA</code> and <code>CREATE DATABASE</code> are analogs.  It can therefore be said that MySQL has implemented cross-database functionality, skipped schema functionality entirely, and provided similar functionality into their implementation of a database.  In summary, Postgres fully supports schemas but lacks some functionality MySQL has with databases, while MySQL does not even attempt to support true schemas.

Oracle has its own spin where creating a user is synonymous with creating a schema.  Thus a database administrator can create a user called PROJECT and then create a table PROJECT.TABLE. Users can exist without schema objects, but an object is always associated with an owner (though that owner may not have privileges to connect to the database).  With the Oracle 'shared-everything' RAC architecture, the same database can be opened by multiple servers concurrently. This is independent of replication, which can also be used, whereby the data is copied for use by different server.  In the Oracle view, the 'database' is a set of files which contains the data while the 'instance' is a set of processes (and memory) through which a database is accessed.

Informix supports multiple databases in a server instance, like MySQL.  It supports the CREATE SCHEMA syntax as a way to group DDL statements into a single unit creating all objects created as a part of the schema as a single owner.  Informix supports a database mode called ANSI mode which supports creating objects with the same name but owned by different users.

The end result is confusion between the database factions.  The Postgres and Oracle communities maintain that one database is all that is needed for one project, per the definition of database.  MySQL and Informix proponents maintain that schemas have no legitimate purpose when the functionality can be achieved with databases.  Postgres adheres to the SQL specification, in a more intuitive fashion (bottom-up), while MySQL’s [[wikt:pragmatic|pragmatic]] counterargument allows their users to get the job done while creating conceptual confusion.

==See also==
* [[Relational database management system]] (includes market share data)
* [[List of relational database management systems]]
* [[Comparison of object-relational database management systems]]
* [[Comparison of database tools]]
* [[Object Database]] - some of which have relational (SQL/ODBC) interfaces.

==References==
{{reflist|colwidth=30em}}

==External links==
{{wikibooks|SQL dialects reference}}
* [http://troels.arvin.dk/db/rdbms/ Comparison of different SQL implementations against SQL standards]. Includes Oracle, DB2, Microsoft SQL Server, MySQL and PostgreSQL. <small>(08/Jun/2007)</small>
* [http://www.wisdomforce.com/resources/docs/MSSQL2005_ORACLE10g_compare.pdf Features, strengths and weaknesses comparison between Oracle and MSSQL (independent).]
* [http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt The SQL92 standard]

{{Databases}}

{{DEFAULTSORT:Comparison Of Relational Database Management Systems}}
[[Category:Database software comparisons|Relational databases]]
[[Category:Relational database management systems]]