CSA ISO/IEC 9075 : 0

Foreword
Introduction
1 Scope
2 Normative references
3 Definitions, notations, and conventions
4 Concepts
5 Lexical elements
6 Scalar expressions
7 Query expressions
8 Predicates
9 Data assignment rules
10 Additional common elements
11 Schema definition and manipulation
12 Module
13 Data manipulation
14 Transaction management
15 Connection management
16 Session management
17 Dynamic SQL
18 Diagnostics management
19 Embedded SQL
20 Direct invocation of SQL
21 Information Schema and Definition Schema
22 Status codes
23 Conformance
Annex A Leveling the SQL Language
Annex B Implementation-defined elements
Annex C Implementation-dependent elements
Annex D Deprecated features
Annex E Incompatibilities with ISO/IEC 9075:1989
Annex F Maintenance and interpretation of SQL
Index
Tables

Defines the data structures and basic operations on SQL- data. Provides functional capabilities for creating, accessing, maintaining, controlling, and protecting SQL-data. 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 of SQL-data and cursors, and - for declaring database language procedures and embedding them into a standard programming language. Also specifies an Information Schema that describes the structure and the integrity constraints of SQL-data. This standard: - provides a vehicle for portability of data definitions and compilation units between SQL-implementations, - provides a vehicle for interconnection of SQL-implementations, - specifies syntax for embedding SQL-statements in a compilation unit that otherwise conforms to the standard for a particular programming language. It defines how an equivalent compilation unit may be derived that conforms to the particular programming language standard. In that equivalent compilation unit, each embedded SQL-statement has been replaced by statements that invoke a database language procedure that contains the SQL-statement, and - specifies syntax for direct invocation of SQL-statements.