SQL:2003: Difference between revisions

Revision as of 01:52, 15 May 2006

Latest revision as of 03:07, 20 July 2025

(98 intermediate revisions by 71 users not shown)

Line 1:

{{Short description|2003 edition of the SQL standard}}

{{dablink|This article is about '''SQL:2003''', the third revision of the [[SQL]] standard. For more information about SQL, see the main [[SQL]] article.}}

{{SQL language revisions}}

{{namespace|title=SQL:2003}}

'''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#Interoperability and standardization|SQL]]. It was updated by [[SQL:2006]].

==New features==

'''SQL:2003''' is the fifth revision of the [[SQL]] [[database]] [[query language]].

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:<ref>{{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 <!-- Bot retrieved archive --> |archivedate = 2007-11-11|display-authors=etal|url-access=subscription}}</ref>

* [[XML]]-related features ([[SQL/XML]])

* [[Window function (SQL)|Window functions]]

* the sequence generator, which allows standardized sequences

* two new column types: auto-generated values and identity-columns

* the new [[Merge (SQL)|MERGE]] statement

* extensions to the [[Data Definition Language|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 (SQL)|window function]].<ref name="JensenPedersen2010">{{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}}</ref>

For details see.<ref>[http://sigmodrecord.org/publications/sigmodRecord/0403/E.JimAndrew-standard.pdf SQL:2003 Has Been Published]</ref>

Introduced XML-related features, ''window functions'', standardized sequences and columns with auto-generated values (including identity-columns).

==Documentation availability==

The SQL standard is not freely available. SQL:2003but 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] {{Webarchive|url=https://web.archive.org/web/20160330011635/http://www.wiscorp.com/sql_2003_standard.zip |date=2016-03-30 }} from [http://www.wiscorp.com/ Whitemarsh Information Systems Corporation]. The zip archive contains a number of [[Portable Document Format|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] &ndash; SQL/Framework

* [http://www.acm.org/sigmod/record/issues/0403/index.html#standards Eisenberg et al.: ''SQL:2003 Has Been Published'']

{{SQL}}

{{DEFAULTSORT:Sql:2003}}

[[Category:SQL| *]]

[[Category:Declarative programming languages]]

[[Category:ProgrammingQuery languages]]

{{Compu-soft-stub}}