The Definitive Guide to SQLite

APPENDIX ASQL Reference

The SQLite library understands most of the standard SQL language. But it does omit some features while at the same time adding a few features of its own. This reference is an overview of the SQL syntax implemented by SQLite, taken directly from the original documentation on the SQLite website (www.sqlite.org/lang.html) and slightly edited. Many low-level productions are omitted. For detailed information on the language that SQLite understands, refer to the source code and the grammar file parse.y in the source distribution.

In all of the syntax diagrams that follow, literal text is shown in bold. Nonterminal symbols are shown in italic. Operators that are part of the syntactic markup itself are shown as regular, unformatted ...