SQL:2003

This article is about SQL:2003, a revision of the SQL standard. For more information about SQL, see the main SQL article.

SQL:2003 is the fifth revision of the SQL database query language. The latest revision of the standard is SQL:2008.

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:^[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

Documentation availability

The SQL standard is not freely available. SQL:2003 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.

ISO/IEC 9075(1-4,9-11,13,14):2003 CD-ROM (352 CHF, or approximately 225 EUR, to order the CD)
- ISO/IEC 9075-1:2003 – Framework (SQL/Framework)
- ISO/IEC 9075-2:2003 – Foundation (SQL/Foundation)
- ISO/IEC 9075-3:2003 – Call-Level Interface (SQL/CLI)
- ISO/IEC 9075-4:2003 – Persistent Stored Modules (SQL/PSM)
- ISO/IEC 9075-9:2003 – Management of External Data (SQL/MED)
- ISO/IEC 9075-10:2003 – Object Language Bindings (SQL/OLB)
- ISO/IEC 9075-11:2003 – Information and Definition Schemas (SQL/Schemata)
- ISO/IEC 9075-13:2003 – SQL Routines and Types Using the Java Programming Language (SQL/JRT)
- ISO/IEC 9075-14:2003 – XML-Related Specifications (SQL/XML)

References

↑ {{Expansion depth limit exceeded|{{Expansion depth limit exceeded|[[{{{Expansion depth limit exceeded}}} |{{{Expansion depth limit exceeded}}}{{Expansion depth limit exceeded|, {{{Expansion depth limit exceeded}}} }}]] |{{{Expansion depth limit exceeded}}}{{Expansion depth limit exceeded|, {{{Expansion depth limit exceeded}}} }} }}{{Expansion depth limit exceeded|{{Expansion depth limit exceeded|; |{{Expansion depth limit exceeded| & |; }} }}{{Expansion depth limit exceeded|[[{{{Expansion depth limit exceeded}}} |{{{Expansion depth limit exceeded}}}{{Expansion depth limit exceeded|, {{{Expansion depth limit exceeded}}} }}]] |{{{Expansion depth limit exceeded}}}{{Expansion depth limit exceeded|, {{{Expansion depth limit exceeded}}} }} }}{{Expansion depth limit exceeded|{{Expansion depth limit exceeded|; |{{Expansion depth limit exceeded| & |; }} }}{{Expansion depth limit exceeded|[[{{{Expansion depth limit exceeded}}} |{{{Expansion depth limit exceeded}}}{{Expansion depth limit exceeded|, {{{Expansion depth limit exceeded}}} }}]] |{{{Expansion depth limit exceeded}}}{{Expansion depth limit exceeded|, {{{Expansion depth limit exceeded}}} }} }}{{Expansion depth limit exceeded| et al. }} }} }}, ed{{Expansion depth limit exceeded|s}}{{Expansion depth limit exceeded|.||.}}{{Expansion depth limit exceeded| ({{{Expansion depth limit exceeded}}}){{Expansion depth limit exceeded| [{{{Expansion depth limit exceeded}}}] }} }} }}{{Expansion depth limit exceeded|, }}{{Expansion depth limit exceeded| 1={{Expansion depth limit exceeded|{{{Expansion depth limit exceeded}}} |{{Expansion depth limit exceeded|{{{Expansion depth limit exceeded}}} |{{Expansion depth limit exceeded|{{Expansion depth limit exceeded|http://www.pubmedcentral.nih.gov/articlerender.fcgi?tool=pmcentrez&artid={{{Expansion depth limit exceeded}}} }} }} }} }} | 2={{Expansion depth limit exceeded|Expansion depth limit exceeded{{{Expansion depth limit exceeded}}}Expansion depth limit exceeded |"{{Expansion depth limit exceeded|{{Expansion depth limit exceeded| }}[{{{Expansion depth limit exceeded}}}] }}" }} }}{{Expansion depth limit exceeded|{{Expansion depth limit exceeded|, }} {{Expansion depth limit exceeded| 1={{Expansion depth limit exceeded|{{Expansion depth limit exceeded|{{Expansion depth limit exceeded|{{{Expansion depth limit exceeded}}} |{{Expansion depth limit exceeded|{{Expansion depth limit exceeded| http://www.pubmedcentral.nih.gov/articlerender.fcgi?tool=pmcentrez&artid={{{Expansion depth limit exceeded}}} }}}} }} }} |{{Expansion depth limit exceeded|{{{Expansion depth limit exceeded}}} |{{Expansion depth limit exceeded|{{Expansion depth limit exceeded| http://www.pubmedcentral.nih.gov/articlerender.fcgi?tool=pmcentrez&artid={{{Expansion depth limit exceeded}}} }}}} }} }} | 2=Expansion depth limit exceeded{{Expansion depth limit exceeded| [{{{Expansion depth limit exceeded}}}] }}Expansion depth limit exceeded }} }}{{Expansion depth limit exceeded| ({{{Expansion depth limit exceeded}}}) }}{{Expansion depth limit exceeded|, {{{Expansion depth limit exceeded}}} }}{{Expansion depth limit exceeded|, Expansion depth limit exceeded{{{Expansion depth limit exceeded}}}Expansion depth limit exceeded }}{{Expansion depth limit exceeded|, }}{{Expansion depth limit exceeded| ({{{Expansion depth limit exceeded}}} ed.) }}{{Expansion depth limit exceeded|, {{{Expansion depth limit exceeded}}} }}{{Expansion depth limit exceeded|{{Expansion depth limit exceeded|Expansion depth limit exceeded |, }} {{{Expansion depth limit exceeded}}} }}{{Expansion depth limit exceeded|, {{{Expansion depth limit exceeded}}}{{Expansion depth limit exceeded| [{{{Expansion depth limit exceeded}}}] }} }}{{Expansion depth limit exceeded|, {{{Expansion depth limit exceeded}}} }}{{Expansion depth limit exceeded|, {{Expansion depth limit exceeded|.|A|a}}rchived{{Expansion depth limit exceeded|{{Expansion depth limit exceeded| from {{Expansion depth limit exceeded||the original}}}} }}{{Expansion depth limit exceeded| on {{{Expansion depth limit exceeded}}} }}{{Expansion depth limit exceeded|. {{Expansion depth limit exceeded|If you specify |{{Expansion depth limit exceeded|archiveurl|archivedate}}=, you must {{Expansion depth limit exceeded| also specify |{{Expansion depth limit exceeded|archivedate|archiveurl}}=|first specify |url=}}}} }} }}.<span class="Z3988" title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook{{Expansion depth limit exceeded|&rft.genre=bookitem&rft.btitle={{Expansion depth limit exceeded}}&rft.atitle={{Expansion depth limit exceeded}} |&rft.genre=book&rft.btitle={{Expansion depth limit exceeded}} }}&rfr_id=info:sid/en.wikipedia.org:SQL:2003">

External links

BNF Grammar for ISO/IEC 9075-1:2003 – SQL/Framework
BNF Grammar for ISO/IEC 9075-2:2003 – SQL/Foundation

File:HelloWorld.svg

This programming language-related article is a stub. You can help Wikipedia by expanding it.

This box: [[{{Expansion depth limit exceeded|#default = {{Expansion depth limit exceeded}}

|{{Expansion depth limit exceeded}} = 
   {{Expansion depth limit exceeded| {{Expansion depth limit exceeded}}
     | Template:{{{Expansion depth limit exceeded}}}            
     | {{Expansion depth limit exceeded}}      
   }}

}}|view]] • [[|talk]] • [{{Expansion depth limit exceeded|action=edit}}{{Expansion depth limit exceeded|e|edit}}]

Stub icon

This database-related article is a stub. You can help Wikipedia by expanding it.

This box: [[{{Expansion depth limit exceeded|#default = {{Expansion depth limit exceeded}}

|{{Expansion depth limit exceeded}} = 
   {{Expansion depth limit exceeded| {{Expansion depth limit exceeded}}
     | Template:{{{Expansion depth limit exceeded}}}            
     | {{Expansion depth limit exceeded}}      
   }}

}}|view]] • [[|talk]] • [{{Expansion depth limit exceeded|action=edit}}{{Expansion depth limit exceeded|e|edit}}]

es:SQL:2003 ru:SQL:2003

If you like SEOmastering Site, you can support it by - BTC: bc1qppjcl3c2cyjazy6lepmrv3fh6ke9mxs7zpfky0 , TRC20 and more...

→

[1] {{Expansion depth limit exceeded|{{Expansion depth limit exceeded|[[{{{Expansion depth limit exceeded}}} |{{{Expansion depth limit exceeded}}}{{Expansion depth limit exceeded|, {{{Expansion depth limit exceeded}}} }}]] |{{{Expansion depth limit exceeded}}}{{Expansion depth limit exceeded|, {{{Expansion depth limit exceeded}}} }} }}{{Expansion depth limit exceeded|{{Expansion depth limit exceeded|; |{{Expansion depth limit exceeded| & |; }} }}{{Expansion depth limit exceeded|[[{{{Expansion depth limit exceeded}}} |{{{Expansion depth limit exceeded}}}{{Expansion depth limit exceeded|, {{{Expansion depth limit exceeded}}} }}]] |{{{Expansion depth limit exceeded}}}{{Expansion depth limit exceeded|, {{{Expansion depth limit exceeded}}} }} }}{{Expansion depth limit exceeded|{{Expansion depth limit exceeded|; |{{Expansion depth limit exceeded| & |; }} }}{{Expansion depth limit exceeded|[[{{{Expansion depth limit exceeded}}} |{{{Expansion depth limit exceeded}}}{{Expansion depth limit exceeded|, {{{Expansion depth limit exceeded}}} }}]] |{{{Expansion depth limit exceeded}}}{{Expansion depth limit exceeded|, {{{Expansion depth limit exceeded}}} }} }}{{Expansion depth limit exceeded| et al. }} }} }}, ed{{Expansion depth limit exceeded|s}}{{Expansion depth limit exceeded|.||.}}{{Expansion depth limit exceeded| ({{{Expansion depth limit exceeded}}}){{Expansion depth limit exceeded| [{{{Expansion depth limit exceeded}}}] }} }} }}{{Expansion depth limit exceeded|, }}{{Expansion depth limit exceeded| 1={{Expansion depth limit exceeded|{{{Expansion depth limit exceeded}}} |{{Expansion depth limit exceeded|{{{Expansion depth limit exceeded}}} |{{Expansion depth limit exceeded|{{Expansion depth limit exceeded|http://www.pubmedcentral.nih.gov/articlerender.fcgi?tool=pmcentrez&artid={{{Expansion depth limit exceeded}}} }} }} }} }} | 2={{Expansion depth limit exceeded|Expansion depth limit exceeded{{{Expansion depth limit exceeded}}}Expansion depth limit exceeded |"{{Expansion depth limit exceeded|{{Expansion depth limit exceeded| }}[{{{Expansion depth limit exceeded}}}] }}" }} }}{{Expansion depth limit exceeded|{{Expansion depth limit exceeded|, }} {{Expansion depth limit exceeded| 1={{Expansion depth limit exceeded|{{Expansion depth limit exceeded|{{Expansion depth limit exceeded|{{{Expansion depth limit exceeded}}} |{{Expansion depth limit exceeded|{{Expansion depth limit exceeded| http://www.pubmedcentral.nih.gov/articlerender.fcgi?tool=pmcentrez&artid={{{Expansion depth limit exceeded}}} }}}} }} }} |{{Expansion depth limit exceeded|{{{Expansion depth limit exceeded}}} |{{Expansion depth limit exceeded|{{Expansion depth limit exceeded| http://www.pubmedcentral.nih.gov/articlerender.fcgi?tool=pmcentrez&artid={{{Expansion depth limit exceeded}}} }}}} }} }} | 2=Expansion depth limit exceeded{{Expansion depth limit exceeded| [{{{Expansion depth limit exceeded}}}] }}Expansion depth limit exceeded }} }}{{Expansion depth limit exceeded| ({{{Expansion depth limit exceeded}}}) }}{{Expansion depth limit exceeded|, {{{Expansion depth limit exceeded}}} }}{{Expansion depth limit exceeded|, Expansion depth limit exceeded{{{Expansion depth limit exceeded}}}Expansion depth limit exceeded }}{{Expansion depth limit exceeded|, }}{{Expansion depth limit exceeded| ({{{Expansion depth limit exceeded}}} ed.) }}{{Expansion depth limit exceeded|, {{{Expansion depth limit exceeded}}} }}{{Expansion depth limit exceeded|{{Expansion depth limit exceeded|Expansion depth limit exceeded |, }} {{{Expansion depth limit exceeded}}} }}{{Expansion depth limit exceeded|, {{{Expansion depth limit exceeded}}}{{Expansion depth limit exceeded| [{{{Expansion depth limit exceeded}}}] }} }}{{Expansion depth limit exceeded|, {{{Expansion depth limit exceeded}}} }}{{Expansion depth limit exceeded|, {{Expansion depth limit exceeded|.|A|a}}rchived{{Expansion depth limit exceeded|{{Expansion depth limit exceeded| from {{Expansion depth limit exceeded||the original}}}} }}{{Expansion depth limit exceeded| on {{{Expansion depth limit exceeded}}} }}{{Expansion depth limit exceeded|. {{Expansion depth limit exceeded|If you specify |{{Expansion depth limit exceeded|archiveurl|archivedate}}=, you must {{Expansion depth limit exceeded| also specify |{{Expansion depth limit exceeded|archivedate|archiveurl}}=|first specify |url=}}}} }} }}.<span class="Z3988" title="ctx_ver=Z39.88-2004&rft_val_fmt=info%3Aofi%2Ffmt%3Akev%3Amtx%3Abook{{Expansion depth limit exceeded|&rft.genre=bookitem&rft.btitle={{Expansion depth limit exceeded}}&rft.atitle={{Expansion depth limit exceeded}} |&rft.genre=book&rft.btitle={{Expansion depth limit exceeded}} }}&rfr_id=info:sid/en.wikipedia.org:SQL:2003">

[1]

SQL:2003

Contents

Summary

Documentation availability

References

External links

Navigation menu

Page actions

Page actions

Personal tools

Navigation

Search

Seo Tools

Tools

Main Categories