SQL:2008

Quality 0.50 · 2 views · Updated 2 months ago

2008 edition of the SQL standard

title: "SQL:2008" type: doc version: 1 created: 2026-02-28 author: "Wikipedia contributors" status: active scope: public tags: ["sql", "declarative-programming-languages", "query-languages", "computer-related-introductions-in-2008"] description: "2008 edition of the SQL standard" topic_path: "technology/databases" source: "https://en.wikipedia.org/wiki/SQL:2008" license: "CC BY-SA 4.0" wikipedia_page_id: 0 wikipedia_revision_id: 0

::summary 2008 edition of the SQL standard ::

SQL:2008 is the sixth revision of the ISO and ANSI standard for the SQL database query language. It was formally adopted in July 2008. The standard consists of 9 parts which are described in detail in SQL. The next iteration is SQL: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 triggers,
partitioned JOIN tables,
support for various XQuery regular expression/pattern-matching features, and
enhancements to derived column names.

Documentation

The SQL standards documentation is not freely available but may be purchased from the 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.

References

[http://iablog.sybase.com/paulley/2008/07/sql2008-now-an-approved-iso-international-standard/ SQL:2008 now an approved ISO International Standard] {{webarchive. link. (2011-06-28 , a July 29th, 2008 blog post from a [[Sybase]] blog)
[https://docs.oracle.com/cd/E11882_01/server.112/e41084/ap_standard_sql003.htm#SQLRF55516 Oracle Compliance To Core SQL:2008] from [[Oracle Corporation]]

::callout[type=info title="Wikipedia Source"] This article was imported from Wikipedia and is available under the Creative Commons Attribution-ShareAlike 4.0 License. Content has been adapted to SurfDoc format. Original contributors can be found on the article history page. ::