SQL:2003: Difference between revisions

Revision as of 03:30, 24 November 2012

Revision as of 03:31, 24 November 2012

Line 12:

* extensions to the [[Data Definition Language|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 (SQL)|windowingwindow function]].<ref name="JensenPedersen2010">{{cite book|author1=Christian S. Jensen|author2=Torben Bach Pedersen|author3=Christian Thomsen|title=Multidimensional Databases and Data Warehousing|url=http://books.google.com/books?id=7UJpcKbVcYkC&pg=PA26|year=2010|publisher=Morgan & Claypool Publishers|isbn=978-1-60845-537-9|page=26}}</ref>

==Documentation availability==