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. It was updated by 2006.

## Contents

* 1 New features
* 2 Documentation availability
* 3 References
* 4 External links

## New features

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

* 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 1999) were extended with a window function.[2]

For details see.[3]

## 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

1. ↑ Eisenberg, Andrew (March 2004). "SQL:2003 Has Been Published" (pdf). SIGMOD Record 33 (1): 119–126. doi:10.1145/974121.974142. Archived from the original on 2007-11-11. https://web.archive.org/web/20071111200042/http://www.acm.org/sigmod/record/issues/0403/index.html#standards. Retrieved 2007-08-14.
2. ↑ Christian S. Jensen; Torben Bach Pedersen; Christian Thomsen (2010). Multidimensional Databases and Data Warehousing. Morgan & Claypool Publishers. p. 26. ISBN 978-1-60845-537-9. https://books.google.com/books?id=7UJpcKbVcYkC&pg=PA26.
3. ↑ SQL:2003 Has Been Published

## External links

* BNF Grammar for ISO/IEC 9075:2003 - SQL/Framework

* v
* t
* e

SQL

Versions|

* SQL-86
* SQL-89
* SQL-92
* 1999
* 2003
* 2006
* 2008
* 2011
* 2016

Keywords|

* As
* Case
* Create
* Delete
* From
* Having
* Insert
* Join
* Merge
* Null
* Order by
* Prepare
* Select
* Truncate
* Union
* Update
* Where
* With

Related|

* Edgar Codd
* Relational database

ISO/IEC SQL parts|

* Framework
* Foundation
* Call-Level Interface
* Persistent Stored Modules
* Management of External Data
* Object Language Bindings
* Information and Definition Schemas
* SQL Routines and Types for the Java Programming Language
* XML-Related Specifications

0.00

(0 votes)

Original source: https://en.wikipedia.org/wiki/SQL:2003. Read more

|

Retrieved from "https://handwiki.org/wiki/index.php?title=SQL:2003&oldid=4349296"
*[v]: View this template
*[t]: Discuss this template
*[e]: Edit this template