ISO/IEC 9075-2:2003
Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation)

Standard No.

ISO/IEC 9075-2:2003

Release Date

2003

Published By

International Organization for Standardization (ISO)

Status

Withdraw

Replace By

ISO/IEC 9075-2:1999/Amd 1:2001/Cor 1:2003

Latest

ISO/IEC 9075-2:2023

Scope

This part of ISO/IEC 9075 defines the data structures and basic operations on SQL-data. It provides functional capabilities for creating, accessing, maintaining, controlling, and protecting SQL-data. This part of ISO/IEC 9075 specifies the syntax and semantics of a database language: — For specifying and modifying the structure and the integrity constraints of SQL-data. — For declaring and invoking operations on SQL-data and cursors. — For declaring database language procedures. — For embedding SQL-statements in a compilation unit that otherwise conforms to the standard for a particular programming language (host language). — For deriving an equivalent compilation unit that conforms to the particular programming language standard. In that equivalent compilation unit, each embedded SQL-statement has been replaced by one or more statements in the host language, some of which invoke an SQL externally-invoked procedure that, when executed, has an effect equivalent to executing the SQL-statement. — For direct invocation of SQL-statements. — To support dynamic preparation and execution of SQL-statements. This part of ISO/IEC 9075 provides a vehicle for portability of data definitions and compilation units between SQL-implementations. This part of ISO/IEC 9075 provides a vehicle for interconnection of SQL-implementations. Implementations of this part of ISO/IEC 9075 may exist in environments that also support application programming languages, end-user query languages, report generator systems, data dictionary systems, program library systems, and distributed communication systems, as well as various tools for database design, data administration, and performance optimization.

ISO/IEC 9075-2:2003 history

• 2023 ISO/IEC 9075-2:2023 Information technology — Database languages SQL — Part 2: Foundation (SQL/Foundation)
• 2022 ISO/IEC 9075-2:2016/Cor 2:2022 Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation) — Technical Corrigendum 2
• 2019 ISO/IEC 9075-2:2016/Cor 1:2019 Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation) — Technical Corrigendum 1
• 2016 ISO/IEC 9075-2:2016 Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation)
• 2015 ISO/IEC 9075-2:2011/Cor 2:2015 Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation); Technical Corrigendum 2
• 2013 ISO/IEC 9075-2:2011/Cor 1:2013 Information technology.Database languages - SQL.Part 2: Foundation (SQL/Foundation); Technical Corrigendum 1
• 2011 ISO/IEC 9075-2:2011 Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation)
• 2010 ISO/IEC 9075-2:2008/Cor 1:2010 Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation)
• 2008 ISO/IEC 9075-2:2008 Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation)
• 2007 ISO/IEC 9075-2:2003/Cor 2:2007 Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation); Technical Corrigendum 2
• 2005 ISO/IEC 9075-2:2003/Cor 1:2005 Information technology - Database languages - SQL - Part 2: Fundation (SQL/Foundation); Technical Corrigendum 1
• 2003 ISO/IEC 9075-2:1999/Cor 2:2003 Information technology - Database languages - SQL - Part 2: Grundlagen (SQL/Foundation); Technical Corrigendum 2
• 2001 ISO/IEC 9075-2:1999/Amd 1:2001/Cor 1:2003 Information technology - Database lagnuages; SQL - Part 1: Framework (SQL/Framework); Amendment 1: Online Analytical Processing (SQL/OLAP)
• 2003 ISO/IEC 9075-2:2003 Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation)
• 2001 ISO/IEC 9075-2:1999/Amd 1:2001 Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation) — Amendment 1: On-Line Analytical Processing (SQL/OLAP)
• 2000 ISO/IEC 9075-2:1999/Cor 1:2000 Information technology - Database languages; SQL - Part 2: Foundation (SQL/Foundation); Technical Corrigendum 1
• 1999 ISO/IEC 9075-2:1999 Information technology - Database languages - SQL - Part 2: Grundlagen (SQL/Foundation)