SQL-99 Complete, Really¶
Note
You are reading a digital copy of SQL-99 Complete, Really, a book that documents the SQL-99 standard.
The book and the standard does not reflect the features of CrateDB, we are just publishing it as a service for the community and for reference purposes.
On the one hand, CrateDB does not implement the SQL-99 standard thoroughly, on the other hand, it extends the standard for implementing cluster features and others.
For more information specific to CrateDB, check out the CrateDB Reference documentation.
Table of Contents
- Preface
- Chapters
- Chapter 1 – Introduction
- Chapter 2 – General Concepts
- Chapter 3 – Numbers
- Chapter 4 – Bit strings
- Chapter 5 – Binary strings
- Chapter 6 – Characters
- Chapter 7 – Character strings
- Chapter 8 – Temporal values
- Chapter 9 – Boolean values
- Chapter 10 – Collection types
- Chapter 11 – Row types
- Chapter 12 – Reference types
- Chapter 13 – NULLs
- Chapter 14 – SQL Cluster
- Chapter 15 – SQL Authorizationid
- Chapter 16 – SQL Catalogs
- Chapter 17 – SQL Schema
- Chapter 18 – SQL Table and View
- Chapter 19 – SQL Domain
- Chapter 20 – SQL Constraint and Assertion
- Constraint
- Constraint Descriptors
- Constraint Definition
- Constraint_type – UNIQUE Constraint
- Constraint_type – PRIMARY KEY Constraint
- Constraint_type – FOREIGN KEY Constraint
- Constraint_type – NOT NULL Constraint
- Constraint_type – CHECK Constraint
- CREATE ASSERTION Statement
- Interlocking References
- Dropping Constraints
- DROP ASSERTION Statement
- Dialects
- Chapter 21 – SQL Character Set
- Chapter 22 – SQL Collation
- Chapter 23 – SQL Translation
- Chapter 24 – SQL Trigger
- Chapter 25 – SQL-invoked Routine
- Chapter 26 – PSM: Not just Persistent Stored Modules
- Chapter 27 – User-defined Types
- Chapter 28 – Introduction to SQL-data operations
- Chapter 29 – Simple Search Conditions
- Chapter 30 – Searching with Joins
- Chapter 31 – Searching with Subqueries
- Chapter 32 – Searching with Set Operators
- Chapter 33 – Searching with Groups
- Chapter 34 – Sorting Search Results
- Chapter 35 – Changing SQL-data
- Chapter 36 – SQL Transactions
- Chapter 37 – SQL Transaction Concurrency
- Chapter 38 – SQL Sessions
- Chapter 39 – Embedded SQL Binding Style
- Chapter 40 – SQL/CLI Binding Style
- Chapter 41 – SQL/CLI: env Functions
- Chapter 42 – SQL/CLI: dbc Functions
- Chapter 43 – SQL/CLI: stmt Functions
- Chapter 44 – SQL/CLI Statement Functions
- Chapter 45 – SQL/CLI: Cursor Functions
- Chapter 46 – SQL/CLI: desc Functions
- Chapter 47 – SQL/CLI: Diagnostic Functions
- Chapter 48 – SQL/CLI: General Functions
- Chapter 49 – SQL/CLI: Deferred Parameter Functions
- Chapter 50 – SQL/CLI: Locator Functions
- Chapter 51 – SQL/CLI: Catalog Functions
- Chapter 52 – Module Binding Style
- Chapter 53 – Style
- Appendices