SQL:2003
{{Short description|2003 edition of the SQL standard}}
{{SQL language revisions}}
SQL:2003 is the fifth revision of the SQL database query language. The standard consists of 9 parts which are described in detail in SQL. It was updated by SQL:2006.
New features
The SQL:2003 standard makes minor modifications to all parts of SQL:1999 (also known as SQL3), and officially introduces a few new features such as:{{cite journal|url=http://www.acm.org/sigmod/record/issues/0403/index.html#standards|last=Eisenberg|first=Andrew|title=SQL:2003 Has Been Published|format=pdf|journal=SIGMOD Record|volume=33|issue=1|date=March 2004|accessdate=2007-08-14|doi=10.1145/974121.974142|pages=119–126 |archiveurl = https://web.archive.org/web/20071111200042/http://www.acm.org/sigmod/record/issues/0403/index.html#standards |archivedate = 2007-11-11|display-authors=etal|url-access=subscription}}
- XML-related features (SQL/XML)
- Window functions
- the sequence generator, which allows standardized sequences
- two new column types: auto-generated values and identity-columns
- the new MERGE statement
- extensions to the CREATE TABLE statement, to allow "CREATE TABLE AS" and "CREATE TABLE LIKE"
- removal of the poorly implemented "BIT" and "BIT VARYING" data types
- OLAP capabilities (initially added in SQL:1999) were extended with a window function.{{cite book|author1=Christian S. Jensen|author2=Torben Bach Pedersen|author3=Christian Thomsen|title=Multidimensional Databases and Data Warehousing|url=https://books.google.com/books?id=7UJpcKbVcYkC&pg=PA26|year=2010|publisher=Morgan & Claypool Publishers|isbn=978-1-60845-537-9|page=26}}
For details see.[http://sigmodrecord.org/publications/sigmodRecord/0403/E.JimAndrew-standard.pdf SQL:2003 Has Been Published]
Documentation availability
The SQL standard is not freely available but may be purchased from [http://www.iso.org/ ISO] or [http://webstore.ansi.org/ ANSI]. A late draft is available as a [http://www.wiscorp.com/sql_2003_standard.zip zip archive] from [http://www.wiscorp.com/ Whitemarsh Information Systems Corporation]. The zip archive contains a number of PDF files that define the parts of the SQL:2003 specification.
References
{{reflist}}
External links
- [https://github.com/ronsavage/SQL BNF Grammar for ISO/IEC 9075:2003] – SQL/Framework
{{SQL}}
{{DEFAULTSORT:Sql:2003}}