SQL:2003

Quality 0.50 · 2 views · Updated 2 months ago

2003 edition of the SQL standard

title: "SQL:2003" type: doc version: 1 created: 2026-02-28 author: "Wikipedia contributors" status: active scope: public tags: ["sql", "declarative-programming-languages", "query-languages"] description: "2003 edition of the SQL standard" topic_path: "technology/databases" source: "https://en.wikipedia.org/wiki/SQL:2003" license: "CC BY-SA 4.0" wikipedia_page_id: 0 wikipedia_revision_id: 0

::summary 2003 edition of the SQL standard ::

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:

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.

For details see.

Documentation availability

The SQL standard is not freely available but may be purchased from ISO or ANSI. A late draft is available as a zip archive from Whitemarsh Information Systems Corporation. The zip archive contains a number of PDF files that define the parts of the SQL:2003 specification.

References

Eisenberg, Andrew. (March 2004). "SQL:2003 Has Been Published". SIGMOD Record.
(2010). "Multidimensional Databases and Data Warehousing". Morgan & Claypool Publishers.
[http://sigmodrecord.org/publications/sigmodRecord/0403/E.JimAndrew-standard.pdf SQL:2003 Has Been Published]

::callout[type=info title="Wikipedia Source"] This article was imported from Wikipedia and is available under the Creative Commons Attribution-ShareAlike 4.0 License. Content has been adapted to SurfDoc format. Original contributors can be found on the article history page. ::