Don't Tell Anyone: The SQL Standard is Public!


Picture of ISO/IEC 9075 CD

We all love open source software. Wouldn’t it be great if international standard documents such as the SQL standard would be open too?

As a matter of fact: they are!

However, they are not free—just public. Very much like open source software is not necessarily free. Too often, we neglect these differences. Just because we have to pay for the standard doesn't mean it is secret.

A download of the most relevant part of the SQL standard—part 2—is available for EUR 180 at Austrian Standards. The 2011 version can still be bought for USD 60 at ANSI. It might pay off to check the prices at other ISO members. The SQL standards is not free, but affordable.

Nevertheless there are some free resources that can help you answering questions about the SQL standard:

SQL:2011

Part 1 can be downloaded free of charge from ISO (look for SQL).

Browsable BNF grammar of Part 2 and Part 4.

Drafts of all parts are linked as “SQL:20nn Working Draft Documents” at http://www.wiscorp.com/SQLStandards.html.

Recommended articles (PDF):

SQL:2008

Browsable BNF grammar of Part 2.

SQL:2003

Online validator at http://developer.mimer.se/.

Browsable BNF grammar of Part 2 (alternative source).

SQL:1999

The full content of the book “SQL-99 Complete, Really” is available online and for free at the MariaDB knowledge base. In total conflict to its title, the book only covers Core SQL:1999.

Online validator at http://developer.mimer.se/.

Browsable BNF grammar of Part 2 (alternative source).

SQL-92

A draft of the standard text is available at http://www.contrib.andrew.cmu.edu/~shadow/sql/sql1992.txt.

Online validator at http://developer.mimer.se/.

Browsable BNF grammar of Part 2 (alternative source).

About the Author

Photo of Markus Winand

Markus Winand teaches efficient SQL—inhouse and online. He minimizes the development time using modern SQL and optimizes the runtime with smart indexing—for that he also published the book SQL Performance Explained.

Markus’ Book

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

The essence of SQL tuning in 200 pages.

Buy from Markus
(paperback and/or PDF)

Buy from Amazon
(paperback only)

Hire Markus

…to answer your current SQL questions.

The quick and easy way to benefit from his extensive knowledge and experience. 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 | CC-BY-NC-ND 3.0 license