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.
Wikidata facts
Show 2 more facts
- inception
- 1999-00-00
- publication date
- 1999-12-00
Sources (1)
via Wikidata · CC0
~3 min read
Article
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