ISO/IEC 9075-2:2016
Superseded
A superseded Standard is one, which is fully replaced by another Standard, which is a new edition of the same Standard.
A superseded Standard is one, which is fully replaced by another Standard, which is a new edition of the same Standard.
Hardcopy , PDF , PDF 3 Users , PDF 5 Users , PDF 9 Users
06-01-2023
English
12-14-2016
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 |
CAN/CSA-ISO/IEC 9075-2:18 | 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 |
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) |
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) |
INCITS/ISO/IEC 9075-14 : 2012 | INFORMATION TECHNOLOGY - DATABASE LANGUAGES - SQL - PART 14: XML-RELATED SPECIFICATIONS (SQL/XML) |
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) |
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) |
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) |
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) |
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) |
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) |
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) |
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 |
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) |
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 |
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) |
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) |
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) |
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) |
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) |
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 |
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) |
Please Login or Create an Account so you can add users to your Multi user PDF Later.
Important note : All end users must be registered with an Account prior to user licenses being assigned.
Users cannot be edited or removed once added to your Multi user PDF.
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.