ISO/IEC 9075
{{Short description|SQL standard}}
{{SQL language revisions}}
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.
History
The first edition was based on ANSI SQL.{{cite web |url=https://blog.ansi.org/2018/10/sql-standard-iso-iec-9075-2016-ansi-x3-135/ |title=The SQL Standard – ISO/IEC 9075:2016 (ANSI X3.135) |last=Kelechava |first=Brad |date=October 5, 2018 |publisher=American National Standards Institute |access-date=April 23, 2023 }}
Editions
Chronological overview of the editions (which have the year of publication in their name):
- SQL-86 ANSI X3.135:1986
- SQL-87 ISO/IEC 9075:1987 - 1st edition, based on the ANSI standard
- SQL-89, ANSI X3.135-1989, ISO/IEC 9075:1989 - 2nd edition
- SQL-92, ANSI X3.135-1992, 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-14:2006 - (adds Part 14)
- 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:2019, ISO/IEC 9075-15:2019 - (adds Part 15)
- SQL:2023, ISO/IEC 9075:2023 - 9th edition
New editions of the ISO standard are published regularly.
References
{{reflist}}
External links
- [https://www.iso.org/committee/45342.html ISO/IEC JTC 1/SC 32 technical committee (data management and interchange)]