SQL:1999
Sign in to saveAlso known as SQL3, SQL 3
SQL:1999 (also called SQL 3) was the fourth revision of the SQL database query language. It introduced many new features, many of which required clarifications in the subsequent SQL:2003. In the meanwhile SQL:1999 is deprecated.
~3 min read
Encyclopedic overview
12 sectionsContents
- Summary
- New features
- Data types
- Boolean data types
- Distinct user-defined types of power
- Structured user-defined types
- Common table expressions and recursive queries
- Some [[OLAP]] capabilities
- Role-based access control
- Keywords
- References
- Further reading
SQL:1999 (also called SQL 3) was the fourth revision of the SQL database query language. It introduced many new features, many of which required clarifications in the subsequent SQL:2003. In the meanwhile SQL:1999 is deprecated.
==Summary== The ISO standard documents were published between 1999 and 2002 in several installments, the first one consisting of multiple parts. Unlike previous editions, the standard's name used a colon instead of a hyphen for consistency with the names of other ISO standards. The first installment of SQL:1999 had five parts: SQL/Framework ISO/IEC 9075-1:1999 SQL/Foundation ISO/IEC 9075-2:1999 SQL/CLI : an updated definition of the extension Call Level Interface, originally published in 1995, also known as CLI-95 ISO/IEC 9075-3:1999 SQL/PSM : an updated definition of the extension Persistent Stored Modules, originally published in 1996, also known as PSM-96 ISO/IEC 9075-4:1999 SQL/Bindings ISO/IEC 9075-5:1999
Excerpted from Wikipedia’s “SQL:1999” article, available under the CC BY-SA 4.0 licence.