SQL Standard Features

Ensure that your SQL isn't caught in the vendor-specific trap. You can maintain portability using our Mimer SQL Validators to test that your SQL statements conform to the SQL standard, and to what standard level they reside.

SQL-2003, Core SQL-2003 and Features

The SQL-2003 standard specification is comprised of Core SQL-2003, a subset of SQL-2003, which is the minimal conformance level for SQL-2003 and various optional packages of features.

Core SQL-2003 includes: all of Entry SQL-92, much of Transitional and Intermediate SQL-92, some of Full SQL-92 and SQL-99 features, as well as new features from SQL-2003.

SQL-99, Core SQL-99 and Features

The SQL-99 standard specification is comprised of Core SQL-99, a subset of SQL-99, which is the minimal conformance level for SQL-99 and various optional packages of features. Core SQL-99 was introduced to encourage DBMS vendors to implement SQL-99.

Core SQL-99 includes: all of Entry SQL-92, much of Transitional and Intermediate SQL-92, some of Full SQL-92 and some SQL-99 features.

SQL Standard Feature overviews

See the following overview charts:

Note! For details on SQL-92, please see the FIPS publication of the standard Database Language SQL (FIPS PUB 127-2).