SQL-99 Complete, Really¶
Note
You are reading a digital copy of SQL-99 Complete, Really, a book that documents the SQL-99 standard.
For more information specific to CrateDB, check out the CrateDB Reference.
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