Syntax Diagrams For SQLite

Basic SQLite Statements:

All SQLite Statements:

sql-stmt-list:

References:   sql-stmt

See also:   lang.html

sql-stmt:

Used by:   sql-stmt-list

References:   alter-table-stmt   analyze-stmt   attach-stmt   begin-stmt   commit-stmt   create-index-stmt   create-table-stmt   create-trigger-stmt   create-view-stmt   create-virtual-table-stmt   delete-stmt   delete-stmt-limited   detach-stmt   drop-index-stmt   drop-table-stmt   drop-trigger-stmt   drop-view-stmt   insert-stmt   pragma-stmt   reindex-stmt   release-stmt   rollback-stmt   savepoint-stmt   select-stmt   update-stmt   update-stmt-limited   vacuum-stmt

See also:   lang.html   lang_explain.html

alter-table-stmt:

Used by:   sql-stmt

References:   column-def

See also:   lang_altertable.html

analyze-stmt:

Used by:   sql-stmt

See also:   lang_analyze.html

attach-stmt:

Used by:   sql-stmt

See also:   lang_attach.html

begin-stmt:

Used by:   sql-stmt

See also:   lang_transaction.html

commit-stmt:

Used by:   sql-stmt

See also:   lang_transaction.html

rollback-stmt:

Used by:   sql-stmt

See also:   lang_savepoint.html   lang_transaction.html

savepoint-stmt:

Used by:   sql-stmt

See also:   lang_savepoint.html

release-stmt:

Used by:   sql-stmt

See also:   lang_savepoint.html

create-index-stmt:

Used by:   sql-stmt

References:   indexed-column

See also:   lang_createindex.html

indexed-column:

Used by:   create-index-stmt   table-constraint

See also:   lang_createindex.html

create-table-stmt:

Used by:   sql-stmt

References:   column-def   select-stmt   table-constraint

See also:   lang_createtable.html

column-def:

Used by:   alter-table-stmt   create-table-stmt

References:   column-constraint   type-name

See also:   lang_altertable.html   lang_createtable.html   lang_createtable.html#tablecoldef

type-name:

Used by:   column-def   expr

References:   signed-number

See also:   lang_createtable.html

column-constraint:

Used by:   column-def

References:   conflict-clause   expr   foreign-key-clause   literal-value   signed-number

See also:   lang_createtable.html   lang_createtable.html#tablecoldef

signed-number:

Used by:   column-constraint   pragma-value   type-name

See also:   lang_expr.html

table-constraint:

Used by:   create-table-stmt

References:   conflict-clause   expr   foreign-key-clause   indexed-column

See also:   lang_createtable.html   lang_createtable.html#constraints   lang_createtable.html#tablecoldef

foreign-key-clause:

Used by:   column-constraint   table-constraint

See also:   lang_altertable.html   lang_createtable.html

conflict-clause:

Used by:   column-constraint   table-constraint

See also:   lang_conflict.html   lang_createtable.html#ckconst

create-trigger-stmt:

Used by:   sql-stmt

References:   delete-stmt   expr   insert-stmt   select-stmt   update-stmt

See also:   lang_createtrigger.html

create-view-stmt:

Used by:   sql-stmt

References:   select-stmt

See also:   lang_createview.html

create-virtual-table-stmt:

Used by:   sql-stmt

See also:   lang_createvtab.html

delete-stmt:

Used by:   create-trigger-stmt   sql-stmt

References:   expr   qualified-table-name

See also:   lang_delete.html

delete-stmt-limited:

Used by:   sql-stmt

References:   expr   ordering-term   qualified-table-name

See also:   lang_delete.html

detach-stmt:

Used by:   sql-stmt

See also:   lang_detach.html

drop-index-stmt:

Used by:   sql-stmt

See also:   lang_dropindex.html

drop-table-stmt:

Used by:   sql-stmt

See also:   lang_droptable.html

drop-trigger-stmt:

Used by:   sql-stmt

See also:   lang_droptrigger.html

drop-view-stmt:

Used by:   sql-stmt

See also:   lang_dropview.html

expr:

Used by:   column-constraint   create-trigger-stmt   delete-stmt   delete-stmt-limited   insert-stmt   join-constraint   ordering-term   result-column   select-core   table-constraint   update-stmt   update-stmt-limited

References:   literal-value   raise-function   select-stmt   type-name

See also:   lang_expr.html

raise-function:

Used by:   expr

See also:   lang_createtrigger.html#undef_before   lang_expr.html

literal-value:

Used by:   column-constraint   expr

See also:   lang_expr.html

numeric-literal:

See also:   lang_expr.html#litvalue

insert-stmt:

Used by:   create-trigger-stmt   sql-stmt

References:   expr   select-stmt

See also:   lang_insert.html

pragma-stmt:

Used by:   sql-stmt

References:   pragma-value

See also:   pragma.html#syntax

pragma-value:

Used by:   pragma-stmt

References:   signed-number

See also:   pragma.html#syntax

reindex-stmt:

Used by:   sql-stmt

See also:   lang_reindex.html

select-stmt:

Used by:   create-table-stmt   create-trigger-stmt   create-view-stmt   expr   insert-stmt   single-source   sql-stmt

References:   compound-operator   ordering-term   select-core

See also:   lang_select.html

select-core:

Used by:   select-stmt

References:   expr   join-source   ordering-term   result-column

See also:   lang_select.html

result-column:

Used by:   select-core

References:   expr

See also:   lang_select.html

join-source:

Used by:   select-core   single-source

References:   join-constraint   join-op   single-source

See also:   lang_select.html

single-source:

Used by:   join-source

References:   join-source   select-stmt

See also:   lang_indexedby.html   lang_select.html

join-op:

Used by:   join-source

See also:   lang_select.html   lang_select.html#fromclause

join-constraint:

Used by:   join-source

References:   expr

See also:   lang_select.html   lang_select.html#fromclause

ordering-term:

Used by:   delete-stmt-limited   select-core   select-stmt   update-stmt-limited

References:   expr

See also:   lang_select.html

compound-operator:

Used by:   select-stmt

See also:   lang_select.html

update-stmt:

Used by:   create-trigger-stmt   sql-stmt

References:   expr   qualified-table-name

See also:   lang_update.html

update-stmt-limited:

Used by:   sql-stmt

References:   expr   ordering-term   qualified-table-name

See also:   lang_update.html

qualified-table-name:

Used by:   delete-stmt   delete-stmt-limited   update-stmt   update-stmt-limited

See also:   lang_delete.html   lang_indexedby.html   lang_update.html

vacuum-stmt:

Used by:   sql-stmt

See also:   lang_vacuum.html

comment-syntax:

See also:   lang_comment.html