CAN/CSA-ISO/IEC 9075-1:18 (R2022)
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 1: Framework (SQL/Framework) (Adopted ISO/IEC 9075-1:2061, fifth edition, 2016-12-15)
English
01-01-2018
20-05-2025
Foreword
Introduction
1 Scope
2 Normative references
3 Definitions and use of terms
4 Concepts
5 The parts of ISO/IEC 9075
6 Notation and conventions used in other parts of ISO/IEC 9075
7 Annexes to the parts of ISO/IEC 9075
8 Conformance
Annex A (informative) - Maintenance and interpretation of SQL
Annex B (informative) - Implementation-defined elements
Annex C (informative) - Implementation-dependent elements
Annex D (informative) - Deprecated features
Annex E (informative) - Incompatibilities with ISO/IEC 9075:2011
Annex F (informative) - SQL feature taxonomy
Annex G (informative) - Defect reports not addressed in this
edition of this part of ISO/IEC 9075
Index
Preface Standards development within the Information Technology sector is harmonized with international standards development. Through the CSA Technical Committee on Information Technology (TCIT), Canadians serve as the SCC Mirror Committee (SMC) on ISO/IEC Joint Technical Committee 1 on Information Technology (ISO/IEC JTC1) for the Standards Council of Canada (SCC), the ISO member body for Canada and sponsor of the Canadian National Committee of the IEC. Also, as a member of the International Telecommunication Union (ITU), Canada participates in the International Telegraph and Telephone Consultative Committee (ITU-T). For brevity, this Standard will be referred to as \"CAN/CSA-ISO/IEC 9075-1\" throughout. This Standard supersedes CAN/CSA-ISO/IEC 9075-1:13 (adopted ISO/IEC 9075-1:2011). Scope This part of ISO/IEC 9075 describes the conceptual framework used in other parts of ISO/IEC 9075 to specify the grammar of SQL and the result of processing statements in that language by an SQL-implementation. This part of ISO/IEC 9075 also defines terms and notation used in the other parts of ISO/IEC 9075.
| DocumentType |
Standard
|
| ISBN |
978-1-4883-0988-5
|
| Pages |
0
|
| PublisherName |
Canadian Standards Association
|
| Status |
Superseded
|
| SupersededBy |
CSA Preface Standards development within the Information Technology sector is harmonized with international standards development. Through the CSA Technical Committee on Information Technology (TCIT), Canadians serve as the SCC Mirror Committee (SMC) on ISO/IEC Joint Technical Committee 1 on Information Technology (ISO/IEC JTC1) for the Standards Council of Canada (SCC), the ISO member body for Canada and sponsor of the Canadian National Committee of the IEC. Also, as a member of the International Telecommunication Union (ITU), Canada participates in the International Telegraph and Telephone Consultative Committee (ITU-T). For brevity, this Standard will be referred to as “CAN/CSA-ISO/IEC 9075-1” throughout. This Standard supersedes CAN/CSA-ISO/IEC 9075-1:13 (adopted ISO/IEC 9075-1:2011). At the time of publication, ISO/IEC 9075-1:2016 is available from ISO and IEC in English only. CSA Group will publish the French version when it becomes available from ISO and IEC. This Standard was reviewed by the CSA TCIT under the jurisdiction of the CSA Strategic Steering Committee on Information and Communications Technology and deemed acceptable for use in Canada. From time to time, ISO/IEC may publish addenda, corrigenda, etc. The TCIT will review these documents for approval and publication. For a listing, refer to the Current Standards Activities page at standardsactivities.csa.ca. This Standard has been formally approved, without modification, by the Technical Committee and has been developed in compliance with Standards Council of Canada requirements for National Standards of Canada. It has been published as a National Standard of Canada by CSA Group. Scope This part of ISO/IEC 9075 describes the conceptual framework used in other parts of ISO/IEC 9075 to specify the grammar of SQL and the result of processing statements in that language by an SQL-implementation. This part of ISO/IEC 9075 also defines terms and notation used in the other parts of ISO/IEC 9075.
| Standards | Relationship |
| ISO/IEC 9075-1:2016 | Identical |
| ISO/IEC 9075-2:2016 | Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation) |
| ISO/IEC 10646:2014 | Information technology — Universal Coded Character Set (UCS) |
| 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 9075-10:2016 | Information technology — Database languages — SQL — Part 10: Object language bindings (SQL/OLB) |
| ISO/IEC 9075-9:2016 | Information technology — Database languages — SQL — Part 9: Management of External Data (SQL/MED) |
| ISO/IEC 9075-13:2016 | Information technology — Database languages — SQL — Part 13: SQL Routines and types using the Java TM programming language (SQL/JRT) |
| ISO/IEC 9075-3:2016 | Information technology — Database languages — SQL — Part 3: Call-Level Interface (SQL/CLI) |
| 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) |