• There are no items in your cart

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
superseded

A superseded Standard is one, which is fully replaced by another Standard, which is a new edition of the same Standard.

Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation)
Available format(s)

Hardcopy , PDF , PDF 3 Users , PDF 5 Users , PDF 9 Users

Superseded date

06-01-2023

Language(s)

English

Published date

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

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)

View more information
US$73.00
Excluding Tax where applicable

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.