ISO/IEC 9075-2:2016
Superseded
Superseded
A superseded Standard is one, which is fully replaced by another Standard, which is a new edition of the same Standard.
View Superseded by
Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation)
Amended by
Available format(s)
Hardcopy , PDF , PDF 3 Users , PDF 5 Users , PDF 9 Users
Superseded date
01-06-2023
Superseded by
Language(s)
English
Published date
14-12-2016
Important note : Users cannot be edited or removed once added to your Multi user PDF.
ISO/IEC 9075-2:2016 defines the data structures and basic operations on SQL-data. It provides functional capabilities for creating, accessing, maintaining, controlling, and protecting SQL-data.
ISO/IEC 9075-2:2016 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 is otherwise written in a particular programming language (host language).
- For deriving an equivalent compilation unit in the host language. In that equivalent compilation unit, each which invoke an SQL externally-invoked procedure that, when executed, has an effect equivalent to exe-cuting the SQL-statement.
- For direct invocation of SQL-statements.
- To support dynamic preparation and execution of SQL-statements.
ISO/IEC 9075-2:2016 provides a vehicle for portability of data definitions and compilation units between SQL-implementations.
ISO/IEC 9075-2:2016 provides a vehicle for interconnection of SQL-implementations.
Implementations of this ISO/IEC 9075-2:2016 can exist in environments that also support application program-ming 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.
| Committee |
ISO/IEC JTC 1/SC 32
|
| DevelopmentNote |
Supersedes ISO/IEC 9075 (03/2001)
|
| DocumentType |
Standard
|
| Pages |
1707
|
| PublisherName |
International Organization for Standardization
|
| Status |
Superseded
|
| SupersededBy | |
| Supersedes |
| Standards | Relationship |
| NEN-ISO/IEC 9075-2:2016/C1:2019 | Identical |
| BS ISO/IEC 9075 1-4,9-11,13-14:2010 | Identical |
| BS ISO/IEC 9075-2:1999 | Identical |
| INCITS/ISO/IEC 9075-2 : 2012 | Identical |
| CAN/CSA-ISO/IEC 9075-2:18 | Identical |
| CSA ISO/IEC 9075-2A : 2003 | Identical |
| BS ISO/IEC 9075 1-4, 9-11, 13-14:2016 | Identical |
| ISO/IEC 9075-10:2016 | Information technology — Database languages — SQL — Part 10: Object language bindings (SQL/OLB) |
| 12/30232747 DC : DRAFT JAN 2013 | BS ISO/IEC 29182-4 - INFORMATION TECHNOLOGY-SENSOR NETWORKS: SENSOR NETWORK REFERENCE ARCHITECTURE (SNRA) - PART 4: ENTITY MODELS |
| BS ISO 19125-2 : 2004 AMD 16387 | GEOGRAPHIC INFORMATION - SIMPLE FEATURE ACCESS - PART 2: SQL OPTION |
| PD ISO/IEC TR 19075-6:2017 | Information technology. Database languages. SQL Technical Reports SQL support for JavaScript Object Notation (JSON) |
| BS ISO/IEC 9075-9:2001 | Information technology. Database languages. SQL Management of external data (SQL/MED) |
| ISO/IEC TR 19075-3:2015 | Information technology Database languages SQL Technical Reports Part 3: SQL Embedded in Programs using the JavaTM programming language |
| PD ISO/IEC TR 19075-7:2017 | Information technology. Database languages. SQL Technical Reports Polymorphic table functions in SQL |
| 10/30202045 DC : 0 | BS ISO/IEC 9075-4 - INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 4: PERSISTENT STORED MODULES (SQL/PSM) |
| BS ISO/IEC 9075-10:2000 | Information technology. Database languages. SQL Object Language Bindings (SQL/OLB) |
| INCITS/ISO/IEC 29182-4 : 2014 | INFORMATION TECHNOLOGY - SENSOR NETWORKS: SENSOR NETWORK REFERENCE ARCHITECTURE (SNRA) - PART 4: ENTITY MODELS |
| INCITS/ISO/IEC 9075-1 : 2012 | INFORMATION TECHNOLOGY- DATABASE LANGUAGES - SQL - PART 1: FRAMEWORK (SQL/FRAMEWORK) |
| INCITS/ISO/IEC 9075-14 : 2012 | INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 14: XML-RELATED SPECIFICATIONS (SQL/XML) |
| ISO/IEC 9075-11:2016 | Information technology — Database languages — SQL — Part 11: Information and definition schemas (SQL/Schemata) |
| ISO 19162:2015 | Geographic information Well-known text representation of coordinate reference systems |
| ISO/TS 29002-20:2010 | Industrial automation systems and integration — Exchange of characteristic data — Part 20: Concept dictionary resolution services |
| ISO/IEC 9075-9:2016 | Information technology — Database languages — SQL — Part 9: Management of External Data (SQL/MED) |
| EN ISO 14825:2011 | Intelligent transport systems - Geographic Data Files (GDF) - GDF5.0 (ISO 14825:2011) |
| 07/30082636 DC : 0 | BS ISO/IEC 9075-4 - INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 4: PERSISTENT STORED MODULES (SQL/PSM) |
| BS ISO/IEC 13249-3:2016 | Information technology. Database languages. SQL multimedia and application packages Spatial |
| 10/30205819 DC : 0 | BS ISO 14825 - GEOGRAPHIC DATA FILES - GDF5.0 |
| INCITS/ISO/IEC 9075-9 : 2008 | INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 9: MANAGEMENT OF EXTERNAL DATA (SQL/MED) |
| CAN/CSA-ISO/IEC TR 19075-5:18 | Information technology Database languages SQL Technical Reports Part 5: Row Pattern Recognition in SQL (Adopted ISO/IEC TR 19075-5:2016, first edition, 2016-12-15) |
| 02/656424 DC : DRAFT FEB 2002 | ISO/IEC FCD 13249-1 - INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL MULTIMEDIA AND APPLICATION PACKAGES - PART 1: FRAMEWORK |
| BS ISO/IEC 9075-3:1999 | Information technology. Database languages. SQL Call-level interface (SQL/CLI) |
| 09/30142058 DC : 0 | ISO/IEC 13249-7 - INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL MULTIMEDIA AND APPLICATION PACKAGES - PART 7: HISTORY |
| BS ISO/IEC 9075-1 : 2016 | INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 1: FRAMEWORK (SQL/FRAMEWORK) |
| INCITS/ISO/IEC 9075-3 : 2008 | INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 3: CALL-LEVEL INTERFACE (SQL/CLI) |
| I.S. EN ISO 19125-2:2006 | GEOGRAPHIC INFORMATION - SIMPLE FEATURE ACCESS - PART 2: SQL OPTION |
| PD ISO/IEC TR 19075-1:2011 | Information technology. Database languages. SQL technical reports XQuery regular expression support in SQL |
| BS ISO/IEC 9075-4:1999 | Information technology. Database languages. SQL Persistent stored modules (SQL/PSM) |
| PD ISO/IEC TR 19075-5:2016 | Information technology. Database languages. SQL Technical Reports Row Pattern Recognition in SQL |
| CAN/CSA-ISO/IEC 13249-3:16 | Information technology - Database languages - SQL multimedia and application packages - Part 3: Spatial (Adopted ISO/IEC 13249-3:2016, fifth edition, 2016-01-15) |
| ISO/IEC TR 19075-2:2015 | Information technology Database languages SQL Technical Reports Part 2: SQL Support for Time-Related Information |
| I.S. EN ISO 14825:2011 | INTELLIGENT TRANSPORT SYSTEMS - GEOGRAPHIC DATA FILES (GDF) - GDF5.0 |
| INCITS/ISO/IEC 9075-13 : 2008 | INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 13: SQL ROUTINES AND TYPES USING THE JAVA[TM] PROGRAMMING LANGUAGE (SQL/JRT) |
| ISO/IEC 13249-1:2016 | Information technology Database languages SQL multimedia and application packages Part 1: Framework |
| 10/30202054 DC : 0 | BS ISO/IEC 9075-14 - INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 14: XML-RELATED SPECIFICATIONS (SQL/XML) |
| 10/30202050 DC : 0 | BS ISO/IEC 9075-11 - INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 11: INFORMATION AND DEFINITION SCHEMAS (SQL/SCHEMATA) |
| 14/30260392 DC : 0 | BS ISO/IEC 19763-12 - INFORMATION TECHNOLOGY - METAMODEL FRAMEWORK FOR INTEROPERABILITY (MFI) - PART 12: METAMODEL FOR INFORMATION MODEL REGISTRATION |
| ISO/IEC TR 19075-5:2016 | Information technology Database languages SQL Technical Reports Part 5: Row Pattern Recognition in SQL |
| BS ISO/IEC 19763-12:2015 | Information technology. Metamodel framework for interoperability (MFI) Metamodel for information model registration |
| 15/30277011 DC : 0 | BS ISO/IEC 13249-3 - INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL MULTIMEDIA AND APPLICATION PACKAGES - PART 3: SPATIAL |
| 14/30277524 DC : 0 | BS ISO 19162 - GEOGRAPHIC INFORMATION - WELL KNOWN TEXT REPRESENTATION OF COORDINATE REFERENCE SYSTEMS |
| INCITS/ISO/IEC 9075-5 : 1999 | INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 5: HOST LANGUAGE BINDINGS (SQL/BINDINGS) |
| ISO/IEC 9075-3:2016 | Information technology — Database languages — SQL — Part 3: Call-Level Interface (SQL/CLI) |
| ISO/IEC 9075-4:2016 | Information technology — Database languages — SQL — Part 4: Persistent stored modules (SQL/PSM) |
| ISO/IEC 19763-12:2015 | Information technology — Metamodel framework for interoperability (MFI) — Part 12: Metamodel for information model registration |
| ISO/IEC 9075-13:2016 | Information technology — Database languages — SQL — Part 13: SQL Routines and types using the Java TM programming language (SQL/JRT) |
| UNI EN ISO 14825 : 2012 | INTELLIGENT TRANSPORT SYSTEMS - GEOGRAPHIC DATA FILES (GDF) - GDF5.0 |
| BS ISO/IEC 13249-1:2016 | Information technology. Database languages. SQL multimedia and application packages Framework |
| 00/656688 DC : DRAFT OCT 2000 | ISO/IEC FCD 13238-1 - INFORMATION TECHNOLOGY - DATA MANAGEMENT EXPORT/IMPORT - PART 1: STANDARDIZATION FRAMEWORK |
| ISO/IEC TR 19075-7:2017 | Information technology Database languages SQL Technical Reports Part 7: Polymorphic table functions in SQL |
| PD ISO/IEC TR 19075-2:2015 | Information technology. Database languages. SQL Technical Reports SQL Support for Time-Related Information |
| 10/30202037 DC : 0 | BS ISO/IEC 9075-1 - INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 1: FRAMEWORK (SQL/FRAMEWORK) |
| PD ISO/IEC TR 19075-4:2015 | Information technology. Database languages. SQL Technical Reports SQL with Routines and types using the Java<sup>TM</sup> programming language |
| ISO/IEC TR 19075-1:2011 | Information technology Database languages SQL Technical Reports Part 1: XQuery Regular Expression Support in SQL |
| ISO/IEC 29182-4:2013 | Information technology Sensor networks: Sensor Network Reference Architecture (SNRA) Part 4: Entity models |
| PD ISO/IEC TS 13249-7:2013 | Information technology. Database languages. SQL multimedia and application packages History |
| CSA ISO/IEC 9075-5 : 2002 | INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 5: HOST LANGUAGE BINDINGS (SQL/BINDINGS) |
| PD ISO/IEC TR 10182:2016 | Information technology. Programming languages, their environments and system software interfaces. Guidelines for language bindings |
| 07/30082615 DC : 0 | BS ISO/IEC 9075-1 - INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 1: FRAMEWORK (SQL/FRAMEWORK) |
| BS ISO/IEC 29182-4:2013 | Information technology. Sensor networks: Sensor Network Reference Architecture (SNRA) Entity models |
| 15/30279742 DC : 0 | BS ISO/IEC 9075-1 - INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 1: FRAMEWORK (SQL/FRAMEWORK) |
| 05/30082714 DC : DRAFT MAY 2005 | ISO/IEC 13249-1 - INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL MULTIMEDIA AND APPLICATION PACKAGES - PART 1: FRAMEWORK |
| ANSI INCITS 331.2 : 2000 | INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQLJ - PART 2: SQL TYPES USING THE JAVA TM PROGRAMMING LANGUAGE |
| 07/30133722 DC : 0 | BS ISO/IEC 9075-14 - INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 14: XML - RELATED SPECIFICATIONS (SQL/XML) |
| ANSI INCITS 500 : 2012 | INFORMATION TECHNOLOGY - DATABASE LANGUAGE SQL - ROW PATTERN RECOGNITION (SQL/RPR) |
| INCITS/ISO/IEC 13249-5 : 2001 | INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL MULTIMEDIA AND APPLICATION PACKAGES - PART 5: STILL IMAGE |
| ISO/IEC TR 10182:2016 | Information technology — Programming languages, their environments and system software interfaces — Guidelines for language bindings |
| ISO/IEC TS 13249-7:2013 | Information technology Database languages SQL multimedia and application packages Part 7: History |
| BS ISO 19162:2015 | Geographic information. Well-known text representation of coordinate reference systems |
| ISO 14825:2011 | Intelligent transport systems Geographic Data Files (GDF) GDF5.0 |
| ISO 19125-2:2004 | Geographic information Simple feature access Part 2: SQL option |
| BS EN ISO 19125-2:2006 | Geographic information. Simple feature access SQL option |
| EN ISO 19125-2:2006 | Geographic information - Simple feature access - Part 2: SQL option (ISO 19125-2:2004) |
| ANSI INCITS TR 51 : 2015 | INCITS TECHNICAL REPORT FOR INFORMATION TECHNOLOGY - DATABASE LANGUAGE SQL - ROW PATTERN RECOGNITION IN SQL |
| ISO/IEC TR 19075-4:2015 | Information technology Database languages SQL Technical Reports Part 4: SQL with Routines and types using the JavaTM programming language |
| ISO/IEC 9075-1:2016 | Information technology — Database languages — SQL — Part 1: Framework (SQL/Framework) |
| PD ISO/IEC TR 19075-3:2015 | Information technology. Database languages. SQL Technical Reports SQL Embedded in Programs using the Java<sup>TM</sup> programming language |
| INCITS/ISO/IEC 9075-10 : 2008 | INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 10: OBJECT LANGUAGE BINDINGS (SQL/OLB) |
| 17/30339690 DC : 0 | BS ISO/IEC 9075-15 - INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 15: MULTI-DIMENSIONAL ARRAYS (SQL/MDA) |
| 15/30309650 DC : DRAFT FEB 2015 | BS ISO/IEC 13249-1 - INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL MULTIMEDIA AND APPLICATION PACKAGES - PART 1: FRAMEWORK |
| 07/30082633 DC : 0 | BS ISO/IEC 9075-3 - INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 3: CALL-LEVEL INTERFACE (SQL/CLI) |
| BS ISO/IEC 9075-5:1999 | Information technology. Database languages. SQL Host language bindings (SQL/Bindings) |
| BS ISO/IEC 9075-13:2002 | Information technology. Database languages. SQL SQL routines and types using the Java programming language (SQL/JRT) |
| INCITS/ISO/IEC 9075-11 : 2012 | INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 11: INFORMATION AND DEFINITION SCHEMAS (SQL/SCHEMATA) |
| INCITS/ISO/IEC 9075-4 : 2012 | INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 4: PERSISTENT STORED MODULES (SQL/PSM) |
| INCITS/ISO 19125-2 : 2004 | GEOGRAPHIC INFORMATION - SIMPLE FEATURE ACCESS - PART 2: SQL OPTION |
| ISO/IEC TR 19075-6:2017 | Information technology Database languages SQL Technical Reports Part 6: SQL support for JavaScript Object Notation (JSON) |
| ISO/IEC 9075-5:1999 | Information technology Database languages SQL Part 5: Host Language Bindings (SQL/Bindings) |
| ISO/IEC 9075-14:2016 | Information technology — Database languages — SQL — Part 14: XML-Related Specifications (SQL/XML) |
| ISO/IEC 13249-3:2016 | Information technology Database languages SQL multimedia and application packages Part 3: Spatial |
| BS EN ISO 14825:2011 | Intelligent transport systems. Geographic data files (GDF). GDF5.0 |
| CAN/CSA-ISO/IEC 9075-9:18 | Information technology - Database languages - SQL - Part 9: Management of External Data (SQL/MED) (Adopted ISO/IEC 9075-9:2016, fourth edition, 2016-12-15) |
| CAN/CSA-ISO/IEC 13249-1:18 | Information technology - Database languages - SQL multimedia and application packages - Part 1: Framework (Adopted ISO/IEC 13249-1:2016, fourth edition, 2016-06-01) |
| CAN/CSA-ISO/IEC 9075-1:18 | Information technology - Database languages - SQL - Part 1: Framework (SQL/Framework) (Adopted ISO/IEC 9075-1:2061, fifth edition, 2016-12-15) |
| CAN/CSA-ISO/IEC 9075-10:18 | Information technology - Database languages - SQL - Part 10: Object language bindings (SQL/OLB) (Adopted ISO/IEC 9075-10:2016, fourth edition, 2016-12-15) |
| CAN/CSA-ISO/IEC 9075-4:18 | Information technology - Database languages - SQL - Part 4: Persistent stored modules (SQL/PSM) (Adopted ISO/IEC 9075-4:2016, sixth edition, 2016-12-15) |
| CAN/CSA-ISO/IEC 9075-14:18 | Information technology - Database languages - SQL - Part 14: XML-related specifications (SQL/XML) (Adopted ISO/IEC 9075-14:2016, fifth edition, 2016-12-15) |
| CAN/CSA-ISO/IEC 9075-13:18 | Information technology - Database languages - SQL - Part 13: SQL routines and types using the Java TM programming language (SQL/JRT) (Adopted ISO/IEC 9075-13:2016, fourth edition, 2016-12-15) |
| CAN/CSA-ISO/IEC 9075-3:18 | Information technology - Database languages - SQL - Part 3: Call-Level Interface (SQL/CLI) (Adopted ISO/IEC 9075-3:2016, fifth edition, 2016-12-15) |
| CAN/CSA-ISO/IEC 9075-11:18 | Information technology - Database languages - SQL - Part 11: Information and definition schemas (SQL/Schemata) (Adopted ISO/IEC 9075-11:2016, fourth edition, 2016-12-15) |
| ISO/IEC 16262:2011 | Information technology Programming languages, their environments and system software interfaces ECMAScript language specification |
| ISO/IEC 8859-1:1998 | Information technology 8-bit single-byte coded graphic character sets Part 1: Latin alphabet No. 1 |
| ISO/IEC 10646:2014 | Information technology Universal Coded Character Set (UCS) |
| ISO/IEC 6429:1992 | Information technology Control functions for coded character sets |
| ISO/IEC TR 19075-1:2011 | Information technology Database languages SQL Technical Reports Part 1: XQuery Regular Expression Support in SQL |
| ISO 7185:1990 | Information technology — Programming languages — Pascal |
| ISO/IEC 1989:2014 | Information technology — Programming languages, their environments and system software interfaces — Programming language COBOL |
| ISO/IEC 14651:2016 | Information technology International string ordering and comparison Method for comparing character strings and description of the common template tailorable ordering |
| ISO/IEC 11756:1999 | Information technology Programming languages M |
| ISO/IEC 9075-10:2016 | Information technology — Database languages — SQL — Part 10: Object language bindings (SQL/OLB) |
| ISO 8601:2004 | Data elements and interchange formats Information interchange Representation of dates and times |
| ISO/IEC 10206:1991 | Information technology Progamming languages Extended Pascal |
| ISO/IEC TR 19075-2:2015 | Information technology Database languages SQL Technical Reports Part 2: SQL Support for Time-Related Information |
| ISO/IEC 9075-9:2016 | Information technology — Database languages — SQL — Part 9: Management of External Data (SQL/MED) |
| ISO/IEC 1539-1:2010 | Information technology Programming languages Fortran Part 1: Base language |
| ISO/IEC 9899:2011 | Information technology Programming languages C |
| ISO/IEC 646:1991 | Information technology ISO 7-bit coded character set for information interchange |
| ISO/IEC 9075-13:2016 | Information technology — Database languages — SQL — Part 13: SQL Routines and types using the Java TM programming language (SQL/JRT) |
| AS/NZS ISO 19162:2020 | Geographic information - Well-known text representation of coordinate reference systems |
| ISO/IEC 9075-3:2016 | Information technology — Database languages — SQL — Part 3: Call-Level Interface (SQL/CLI) |
| ISO/IEC/IEEE 9945:2009 | Information technology — Portable Operating System Interface (POSIX®) Base Specifications, Issue 7 |
| ISO 6160:1979 | Programming languages — PL/1 |
| ISO/IEC 8652:2012 | Information technology — Programming languages — Ada |
| ISO/IEC 9075-14:2016 | Information technology — Database languages — SQL — Part 14: XML-Related Specifications (SQL/XML) |
| ISO/IEC 9075-11:2016 | Information technology — Database languages — SQL — Part 11: Information and definition schemas (SQL/Schemata) |
| ISO/IEC 9075-4:2016 | Information technology — Database languages — SQL — Part 4: Persistent stored modules (SQL/PSM) |
| ISO/IEC 9579:2000 | Information technology Remote database access for SQL with security enhancement |
| ISO/IEC 9075-1:2016 | Information technology — Database languages — SQL — Part 1: Framework (SQL/Framework) |
Access your standards online with a subscription
Features
-
Simple online access to standards, technical information and regulations.
-
Critical updates of standards and customisable alerts and notifications.
-
Multi-user online standards collection: secure, flexible and cost effective.