The 16 Parts of SQL


Since SQL:1999 the standard is divided into several parts numbered from 1 though 14 (as of SQL:2016). Some of them were never released (5-8, 12), others never became mainstream. Leaving the meta-part (part 1) aside, only part 2 (the SQL language), part 11 (Information Schema) and part 14 (XML) became widely implemented. Part 15 (MDA) was just released so it is too early to see whether it becomes widespread adopted or not.

Part 1 - Framework

A rough overview and some definitions of commonly used terms. The 2011 version of this part is available for free from ISO (look for SQL).

Part 2 - Foundation

Defines most of the SQL language (other parts extend it—e.g., for XML functionality).

Part 3 - Call-Level Interface (SQL/CLI)

Describes C and COBOL APIs to access SQL databases.

Part 4 - Persisted Stored Modules (SQL/PSM)

Defines a language used for server-side programming (“stored procedures”).

Part 5 - Host Language Bindings (SQL/Bindings)

Merged into part 2 with SQL:2003 (withdrawal notice).

Part 6 - Global Transaction Support (SQL/Transaction)

Never released(?)

Part 7 - Temporal (SQL/Temporal)

Never released. Temporal support was eventually added to SQL:2011 part 2.

Part 8 - Extended Object Support

Never released. Content absorbed into other parts (notice).

Part 9 - Management of External Data (SQL/MED)

Defines mechanisms to access data stored outside the database.

Part 10 - Object Language Bindings (SQL/OLB)

Defines how to embed SQL statements into Java programs. This is not JDBC, which treats SQL statements as strings (“dynamic SQL”).

Part 11 - Information and Definition Schemas (SQL/Schemata)

Defines INFORMATION_SCHEMA and DEFINITION_SCHEMA, which were covered in part 2 prior SQL:2003.

Part 12 - Replication (SQL/Replication)

Never released.

Part 13 - Routines and Types Using the Java Programming Language (SQL/JRT)

Defines how to run Java inside the database.

Part 14 - XML-Related Specifications (SQL/XML)

Defines the XML data type and methods to work on XML documents. Appeared with SQL:2003.

Part 15 - Multi dimensional arrays (SQL/MDA)

First appeared in 2019. See ISO.

Part 16 - Property Graph Query (SQL/PGQ)

In progress. Embeds parts of the new GQL-Standard in SQL. Probably released in 2020 or 2021.

About the Author

Photo of Markus Winand

Markus Winand is the SQL Renaissance Ambassador. He is on a mission to introduce developers to the evolution of SQL in the 21st century. Markus can be hired as trainer, speaker and consultant via winand.at.

Buy his Book on Amazon

Cover of “SQL Performance Explained”: Squirrel running on grass

The essence of SQL tuning in 200 pages

Buy on Amazon
(paperback only)

Paperback and PDF also available at Markus’ store.

Hire Markus

Markus offers SQL training and consulting for developers working at companies of any size.
Learn more »

“modern SQL” by Markus Winand is licensed under a Creative Commons Attribution-Noncommercial-No Derivative Works 3.0 Unported License.
Legal | Contact | NO WARRANTY | Trademarks | Privacy and GDPR | CC-BY-NC-ND 3.0 license