The following tables compare general and technical information for a number of relational database management systems. Please see the individual products articles for further information. This article is not all-inclusive or necessarily up-to-date. Unless otherwise specified in footnotes, comparisons are based on the stable versions without any add-ons, extensions or external programs.

=General information=

=Operating system support=

The operating systems the RDBMSes can run on.

=Fundamental features=

Information about what fundamental RDBMS features are implemented natively.

table type permits storage of values that exceed the data range; some view this as violating the Integrity constraint of ACID.

CHECK and FOREIGN KEY constraints are parsed but are not enforced. Triggers can be used instead. Nested transactions are not supported. [http://www.sqlite.org/omitted.html]

=Tables and views=

Information about what table (database)s and View (database)s #fn_3 (other than basic ones) are supported natively.

, or other procedural languages. One example is here: [http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html].

Server provides tempdb, which can be used for public and private (for the session) temp tables. [http://sybooks.sybase.com/onlinebooks/group-as/asg1250e/sag/@Generic__BookTextView/3225;]

MS SQL server provides indexed views. [http://www.sqlteam.com/item.aspItemID=1015]

=Indexes=

Information about what index (database)es (other than basic B-tree/B plus tree indexes) are supported natively.

A PostgreSQL functional index can be used to reverse the order of a field.

Available via a GiST module [http://www.it.iitb.ac.in/~rvijay/dbms/proj/], not yet in the main distribution.

=Other objects=

Information about what other objects are supported natively.

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.

=Partitioning=

Information about what partition (database) methods are supported natively.

or other procedural languages. [http://developer.postgresql.org/docs/postgres/release.html#RELEASE-8-1]

=See also=

=External links=