View source for SQL:2008

'''SQL:2008''' is the sixth revision of the [[Organization:International Organization for Standardization|ISO]] and ANSI standard for the [[SQL]] [[Database|database]] [[Query language|query language]]. It was formally adopted in July 2008.<ref name="sybase08">[http://iablog.sybase.com/paulley/2008/07/sql2008-now-an-approved-iso-international-standard/ SQL:2008 now an approved ISO International Standard] {{webarchive|url=https://web.archive.org/web/20110628130925/http://iablog.sybase.com/paulley/2008/07/sql2008-now-an-approved-iso-international-standard/ |date=2011-06-28 }}, a July 29th, 2008 blog post from a [[Company:Sybase|Sybase]] blog</ref> The standard consists of 9 parts which are described in detail in [[SQL#Interoperability and standardization|SQL]].  The next iteration is [[SQL:2011|2011]]

==New features==
Additions to the Foundation include 
*enhanced MERGE and DIAGNOSTIC statements,
*the TRUNCATE TABLE statement,
*comma-separated WHEN clauses in a CASE expression,
*INSTEAD OF [[Database trigger|database trigger]]s,
*partitioned JOIN tables,
*support for various [[XQuery]] [[Regular expression|regular expression]]/[[Pattern matching|pattern-matching]] features, and
*enhancements to derived column names.<ref name="sybase08"/>

==Documentation ==
The SQL standards documentation is not freely available but may be purchased from the [[Organization:International Organization for Standardization|ISO]] as ''ISO/IEC 9075(1-4,9-11,13,14):2008''.

==Claims of conformance==
The minimum level of conformance to SQL:2008 that a product can claim is called "Core SQL:2008" and is limited to definitions specified in two parts of the standard: the Foundation and the Information and Definition Schemas.<ref>[https://docs.oracle.com/cd/E11882_01/server.112/e41084/ap_standard_sql003.htm#SQLRF55516 Oracle Compliance To Core SQL:2008] from [[Company:Oracle Corporation|Oracle Corporation]]</ref>

==See also==
{{Wikibook|Structured Query Language}}
*Structured Query Language

==References==
<references />

==External links==
*[http://www.wiscorp.com/SQLStandards.html Freely downloadable drafts of this standard]


[[Category:SQL|* ]]
[[Category:Declarative programming languages]]
[[Category:Query languages]]

{{Sourceattribution|SQL:2008}}