Movatterモバイル変換


[0]ホーム

URL:


Jump to content
WikipediaThe Free Encyclopedia
Search

SQL:2003

From Wikipedia, the free encyclopedia
2003 edition of the SQL standard
SQL language revisions

SQL:2003 is the fifth revision of theSQLdatabasequery language. The standard consists of 9 parts which are described in detail inSQL. It was updated bySQL:2006.

New features

[edit]

The SQL:2003 standard makes minor modifications to all parts ofSQL: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 newMERGE statement
  • extensions to theCREATE 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 inSQL:1999) were extended with awindow function.[2]

For details see.[3]

Documentation availability

[edit]

The SQL standard is not freely available but may be purchased fromISO orANSI. A late draft is available as azip archiveArchived 2016-03-30 at theWayback Machine fromWhitemarsh Information Systems Corporation. The zip archive contains a number ofPDF files that define the parts of the SQL:2003 specification.

References

[edit]
  1. ^Eisenberg, Andrew; et al. (March 2004)."SQL:2003 Has Been Published".SIGMOD Record.33 (1):119–126.doi:10.1145/974121.974142. Archived fromthe original(pdf) on 2007-11-11. Retrieved2007-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.
  3. ^SQL:2003 Has Been Published

External links

[edit]
Versions
Keywords
Related
ISO/IEC SQL parts
Retrieved from "https://en.wikipedia.org/w/index.php?title=SQL:2003&oldid=1301484896"
Categories:
Hidden categories:

[8]ページ先頭

©2009-2026 Movatter.jp