ISO/ IEC 9075 "Information technology - Database languages - SQL" is an international standard for Structured Query Language, and is considered as specifying the minimum for what a database engine should fulfill in terms of SQL syntax, which is called Core SQL. The standard also defines a number of optional features.
The first edition was based on ANSI SQL. [1]
New editions of the ISO standard are published regularly.
Chronological overview of the editions (which have the year of publication in their name):
- SQL-86, ANSI X3.135:1986 [1]
- SQL-87, ISO 9075:1987, based on the ANSI standard [1]
- SQL-89, ISO/IEC 9075:1989
- SQL-92, ISO/IEC 9075:1992 - 3rd edition
- SQL:1999, ISO/IEC 9075:1999 - 4th edition
- SQL:2003, ISO/IEC 9075:2003 - 5th edition
- SQL:2006, ISO/IEC 9075:2006 - (part 14 revision)
- SQL:2008, ISO/IEC 9075:2008 - 6th edition
- SQL:2011, ISO/IEC 9075:2011 - 7th edition
- SQL:2016, ISO/IEC 9075:2016 - 8th edition
- SQL:2023, ISO/IEC 9075:2023 - 9th edition
- ^ a b c Kelechava, Brad (October 5, 2018). "The SQL Standard – ISO/IEC 9075:2016 (ANSI X3.135)". American National Standards Institute. Retrieved April 23, 2023.
ISO/ IEC 9075 "Information technology - Database languages - SQL" is an international standard for Structured Query Language, and is considered as specifying the minimum for what a database engine should fulfill in terms of SQL syntax, which is called Core SQL. The standard also defines a number of optional features.
The first edition was based on ANSI SQL. [1]
New editions of the ISO standard are published regularly.
Chronological overview of the editions (which have the year of publication in their name):
- SQL-86, ANSI X3.135:1986 [1]
- SQL-87, ISO 9075:1987, based on the ANSI standard [1]
- SQL-89, ISO/IEC 9075:1989
- SQL-92, ISO/IEC 9075:1992 - 3rd edition
- SQL:1999, ISO/IEC 9075:1999 - 4th edition
- SQL:2003, ISO/IEC 9075:2003 - 5th edition
- SQL:2006, ISO/IEC 9075:2006 - (part 14 revision)
- SQL:2008, ISO/IEC 9075:2008 - 6th edition
- SQL:2011, ISO/IEC 9075:2011 - 7th edition
- SQL:2016, ISO/IEC 9075:2016 - 8th edition
- SQL:2023, ISO/IEC 9075:2023 - 9th edition
- ^ a b c Kelechava, Brad (October 5, 2018). "The SQL Standard – ISO/IEC 9075:2016 (ANSI X3.135)". American National Standards Institute. Retrieved April 23, 2023.