# SQL:2003

> Mediated Wiki article. Canonical URL: https://mediated.wiki/source/SQL:2003
> Markdown URL: https://mediated.wiki/source/SQL:2003.md
> Source: https://en.wikipedia.org/wiki/SQL%3A2003
> Source revision: 1301484896
> License: Creative Commons Attribution-ShareAlike 4.0 International (https://creativecommons.org/licenses/by-sa/4.0/)

**SQL:2003** is the fifth revision of the [SQL](/source/SQL) [database](/source/Database) [query language](/source/Query_language). The standard consists of 9 parts which are described in detail in [SQL](/source/SQL#Interoperability_and_standardization). It was updated by .

## New features

The SQL:2003 standard makes minor modifications to all parts of (also known as SQL3), and officially introduces a few new features such as:[1]

- [XML](/source/XML)-related features ([SQL/XML](/source/SQL/XML))
- [Window functions](/source/Window_function_(SQL))
- the sequence generator, which allows standardized sequences
- two new column types: auto-generated values and identity-columns
- the new [MERGE](/source/Merge_(SQL)) statement
- extensions to the [CREATE TABLE](/source/Data_Definition_Language) statement, to allow "CREATE TABLE AS" and "CREATE TABLE LIKE"
- removal of the poorly implemented "BIT" and "BIT VARYING" data types
- [OLAP](/source/OLAP) capabilities (initially added in ) were extended with a [window function](/source/Window_function_(SQL)).[2]

For details see.[3]

## Documentation availability

The SQL standard is not freely available but may be purchased from [ISO](http://www.iso.org/) or [ANSI](http://webstore.ansi.org/). A late draft is available as a [zip archive](http://www.wiscorp.com/sql_2003_standard.zip) [Archived](https://web.archive.org/web/20160330011635/http://www.wiscorp.com/sql_2003_standard.zip) 2016-03-30 at the Wayback Machine from [Whitemarsh Information Systems Corporation](http://www.wiscorp.com/). The zip archive contains a number of [PDF](/source/Portable_Document_Format) files that define the parts of the SQL:2003 specification.

## References

1. Eisenberg, Andrew et al. (March 2004). ["SQL:2003 Has Been Published"](http://www.acm.org/sigmod/record/issues/0403/index.html#standards) (pdf). *SIGMOD Record*. **33** (1): 119–126. [doi:10.1145/974121.974142](https://doi.org/10.1145/974121.974142). [Archived](https://web.archive.org/web/20071111200042/http://www.acm.org/sigmod/record/issues/0403/index.html#standards) 2007-11-11 at the Wayback Machine. Retrieved 2007-08-14.

1. Christian S. Jensen; Torben Bach Pedersen; Christian Thomsen (2010). [*Multidimensional Databases and Data Warehousing*](https://books.google.com/books?id=7UJpcKbVcYkC&pg=PA26). Morgan & Claypool Publishers. p. 26. ISBN 978-1-60845-537-9.

1. [SQL:2003 Has Been Published](http://sigmodrecord.org/publications/sigmodRecord/0403/E.JimAndrew-standard.pdf)

## External links

- [BNF Grammar for ISO/IEC 9075:2003](https://github.com/ronsavage/SQL) – SQL/Framework

---
Adapted from the Wikipedia article [SQL:2003](https://en.wikipedia.org/wiki/SQL%3A2003) by Wikipedia contributors ([contributor history](https://en.wikipedia.org/wiki/SQL%3A2003?action=history)). Available under [Creative Commons Attribution-ShareAlike 4.0 International](https://creativecommons.org/licenses/by-sa/4.0/). Changes may have been made.