SQL:2003: Difference between revisions

Revision as of 09:33, 13 September 2007

Revision as of 09:34, 13 September 2007

Line 4:

==Summary==

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|coauthors=et al.|title=SQL:2003 Has Been Published|format=pdf|journal=SIGMOD Record|volume=33|issue=1|month=March|year=2004|accessdate=2007-08-14}}</ref>

* XML-related features

* ''window functions''

Line 12:

* extensions to the [[Create (SQL)|CREATE TABLE]] statement, to allow "CREATE TABLE AS" and "CREATE TABLE LIKE"

* removal of the poorly-implemented "BIT" and "BIT VARYING" data types

==Documentation availability==