Syntax Diagrams For SQLite#

aggregate-function-invocation:#

\ References:   expr   filter-clause   ordering-term\ See also:   lang_aggfunc.html   lang_expr.html#*funcinexpr

alter-table-stmt:#

Used by:   sql-stmt\ References:   column-def   conflict-clause   expr\ See also:   lang_altertable.html

analyze-stmt:#

Used by:   sql-stmt\ See also:   lang_analyze.html

attach-stmt:#

Used by:   sql-stmt\ References:   expr\ See also:   lang_attach.html

begin-stmt:#

Used by:   sql-stmt\ See also:   lang_transaction.html

column-constraint:#

Used by:   column-def\ References:   conflict-clause   expr   foreign-key-clause   literal-value   signed-number\ See also:   gencol.html   lang_altertable.html   lang_createtable.html   lang_createtable.html#tablecoldef

column-def:#

Used by:   alter-table-stmt   create-table-stmt\ References:   column-constraint   type-name\ See also:   lang_altertable.html   lang_altertable.html#altertabaddcol   lang_createtable.html   lang_createtable.html#tablecoldef

column-name-list:#

Used by:   update-stmt   update-stmt-limited   upsert-clause\ See also:   lang_createtrigger.html   lang_insert.html   lang_update.html   lang_upsert.html

comment-syntax:#

\ See also:   lang_comment.html

commit-stmt:#

Used by:   sql-stmt\ See also:   lang_transaction.html

common-table-expression:#

Used by:   compound-select-stmt   delete-stmt   delete-stmt-limited   factored-select-stmt   insert-stmt   select-stmt   simple-select-stmt   update-stmt   update-stmt-limited\ References:   select-stmt\ See also:   lang_aggfunc.html   lang_altertable.html   lang_attach.html   lang_createindex.html   lang_createtable.html   lang_createtrigger.html   lang_createview.html   lang_delete.html   lang_expr.html   lang_insert.html   lang_returning.html   lang_select.html   lang_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

compound-operator:#

Used by:   factored-select-stmt   select-stmt\ See also:   lang_aggfunc.html   lang_altertable.html   lang_attach.html   lang_createindex.html   lang_createtable.html   lang_createtrigger.html   lang_createview.html   lang_delete.html   lang_expr.html   lang_insert.html   lang_returning.html   lang_select.html   lang_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

compound-select-stmt:#

\ References:   common-table-expression   expr   ordering-term   select-core\ See also:   lang_select.html#compound

conflict-clause:#

Used by:   alter-table-stmt   column-constraint   table-constraint\ See also:   lang_altertable.html   lang_conflict.html   lang_createtable.html   lang_createtable.html#notnullconst

create-index-stmt:#

Used by:   sql-stmt\ References:   expr   indexed-column\ See also:   lang_createindex.html   partialindex.html

create-table-stmt:#

Used by:   sql-stmt\ References:   column-def   select-stmt   table-constraint   table-options\ See also:   lang_createtable.html

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

cte-table-name:#

Used by:   recursive-cte   with-clause\ See also:   lang_with.html   lang_with.html#recursivecte

delete-stmt:#

Used by:   create-trigger-stmt   sql-stmt\ References:   common-table-expression   expr   qualified-table-name   returning-clause\ See also:   lang_createtrigger.html   lang_delete.html

delete-stmt-limited:#

Used by:   sql-stmt\ References:   common-table-expression   expr   ordering-term   qualified-table-name   returning-clause\ 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:   aggregate-function-invocation   alter-table-stmt   attach-stmt   column-constraint   compound-select-stmt   create-index-stmt   create-trigger-stmt   delete-stmt   delete-stmt-limited   factored-select-stmt   filter-clause   frame-spec   function-arguments   indexed-column   insert-stmt   join-constraint   ordering-term   over-clause   raise-function   result-column   returning-clause   select-core   select-stmt   simple-function-invocation   simple-select-stmt   table-constraint   table-or-subquery   update-stmt   update-stmt-limited   upsert-clause   window-defn   window-function-invocation\ References:   filter-clause   function-arguments   literal-value   over-clause   raise-function   select-stmt   type-name\ See also:   lang_aggfunc.html   lang_altertable.html   lang_attach.html   lang_createindex.html   lang_createtable.html   lang_createtrigger.html   lang_createview.html   lang_delete.html   lang_expr.html   lang_insert.html   lang_returning.html   lang_select.html   lang_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

factored-select-stmt:#

\ References:   common-table-expression   compound-operator   expr   ordering-term   select-core\ See also:   lang_select.html

filter-clause:#

Used by:   aggregate-function-invocation   expr   window-function-invocation\ References:   expr\ See also:   lang_aggfunc.html   lang_altertable.html   lang_attach.html   lang_createindex.html   lang_createtable.html   lang_createtrigger.html   lang_createview.html   lang_delete.html   lang_expr.html   lang_insert.html   lang_returning.html   lang_select.html   lang_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

foreign-key-clause:#

Used by:   column-constraint   table-constraint\ See also:   lang_altertable.html   lang_altertable.html#altertabaddcol   lang_createtable.html

frame-spec:#

Used by:   over-clause   window-defn\ References:   expr\ See also:   lang_aggfunc.html   lang_altertable.html   lang_attach.html   lang_createindex.html   lang_createtable.html   lang_createtrigger.html   lang_createview.html   lang_delete.html   lang_expr.html   lang_insert.html   lang_returning.html   lang_select.html   lang_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

function-arguments:#

Used by:   expr\ References:   expr   ordering-term\ See also:   lang_aggfunc.html   lang_altertable.html   lang_attach.html   lang_createindex.html   lang_createtable.html   lang_createtrigger.html   lang_createview.html   lang_delete.html   lang_expr.html   lang_insert.html   lang_returning.html   lang_select.html   lang_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

indexed-column:#

Used by:   create-index-stmt   table-constraint   upsert-clause\ References:   expr\ See also:   lang_createindex.html   lang_createtable.html   lang_createtable.html#primkeyconst   lang_createtable.html#uniqueconst   lang_createtrigger.html   lang_insert.html   lang_upsert.html   partialindex.html

insert-stmt:#

Used by:   create-trigger-stmt   sql-stmt\ References:   common-table-expression   expr   returning-clause   select-stmt   upsert-clause\ See also:   lang_createtrigger.html   lang_insert.html

join-clause:#

Used by:   select-core   select-stmt   table-or-subquery   update-stmt   update-stmt-limited\ References:   join-constraint   join-operator   table-or-subquery\ See also:   lang_aggfunc.html   lang_altertable.html   lang_attach.html   lang_createindex.html   lang_createtable.html   lang_createtrigger.html   lang_createview.html   lang_delete.html   lang_expr.html   lang_insert.html   lang_returning.html   lang_select.html   lang_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

join-constraint:#

Used by:   join-clause\ References:   expr\ See also:   lang_aggfunc.html   lang_altertable.html   lang_attach.html   lang_createindex.html   lang_createtable.html   lang_createtrigger.html   lang_createview.html   lang_delete.html   lang_expr.html   lang_insert.html   lang_returning.html   lang_select.html   lang_select.html#compound   lang_select.html#fromclause   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

join-operator:#

Used by:   join-clause\ See also:   lang_aggfunc.html   lang_altertable.html   lang_attach.html   lang_createindex.html   lang_createtable.html   lang_createtrigger.html   lang_createview.html   lang_delete.html   lang_expr.html   lang_insert.html   lang_returning.html   lang_select.html   lang_select.html#compound   lang_select.html#fromclause   lang_select.html#nonstd   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

literal-value:#

Used by:   column-constraint   expr\ See also:   lang_aggfunc.html   lang_altertable.html   lang_attach.html   lang_createindex.html   lang_createtable.html   lang_createtrigger.html   lang_createview.html   lang_delete.html   lang_expr.html   lang_insert.html   lang_returning.html   lang_select.html   lang_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

numeric-literal:#

\ See also:   lang_expr.html#litvalue

ordering-term:#

Used by:   aggregate-function-invocation   compound-select-stmt   delete-stmt-limited   factored-select-stmt   function-arguments   over-clause   select-stmt   simple-select-stmt   update-stmt-limited   window-defn\ References:   expr\ See also:   lang_aggfunc.html   lang_altertable.html   lang_attach.html   lang_createindex.html   lang_createtable.html   lang_createtrigger.html   lang_createview.html   lang_delete.html   lang_expr.html   lang_insert.html   lang_returning.html   lang_select.html   lang_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

over-clause:#

Used by:   expr\ References:   expr   frame-spec   ordering-term\ See also:   lang_aggfunc.html   lang_altertable.html   lang_attach.html   lang_createindex.html   lang_createtable.html   lang_createtrigger.html   lang_createview.html   lang_delete.html   lang_expr.html   lang_insert.html   lang_returning.html   lang_select.html   lang_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.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

qualified-table-name:#

Used by:   delete-stmt   delete-stmt-limited   update-stmt   update-stmt-limited\ See also:   lang_createtrigger.html   lang_delete.html   lang_indexedby.html   lang_update.html

raise-function:#

Used by:   expr\ References:   expr\ See also:   lang_aggfunc.html   lang_altertable.html   lang_attach.html   lang_createindex.html   lang_createtable.html   lang_createtrigger.html   lang_createtrigger.html#raise   lang_createview.html   lang_delete.html   lang_expr.html   lang_insert.html   lang_returning.html   lang_select.html   lang_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

recursive-cte:#

\ References:   cte-table-name\ See also:   lang_with.html#recursivecte

reindex-stmt:#

Used by:   sql-stmt\ See also:   lang_reindex.html

release-stmt:#

Used by:   sql-stmt\ See also:   lang_savepoint.html

result-column:#

Used by:   select-core   select-stmt\ References:   expr\ See also:   lang_aggfunc.html   lang_altertable.html   lang_attach.html   lang_createindex.html   lang_createtable.html   lang_createtrigger.html   lang_createview.html   lang_delete.html   lang_expr.html   lang_insert.html   lang_returning.html   lang_select.html   lang_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

returning-clause:#

Used by:   delete-stmt   delete-stmt-limited   insert-stmt   update-stmt   update-stmt-limited\ References:   expr\ See also:   lang_createtrigger.html   lang_delete.html   lang_insert.html   lang_returning.html   lang_update.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

select-core:#

Used by:   compound-select-stmt   factored-select-stmt   simple-select-stmt\ References:   expr   join-clause   result-column   table-or-subquery   window-defn\ See also:   lang_select.html   lang_select.html#compound   lang_select.html#simpleselect

select-stmt:#

Used by:   common-table-expression   create-table-stmt   create-trigger-stmt   create-view-stmt   expr   insert-stmt   sql-stmt   table-or-subquery   with-clause\ References:   common-table-expression   compound-operator   expr   join-clause   ordering-term   result-column   table-or-subquery   window-defn\ See also:   changes.html#version_3_35_3   lang_aggfunc.html   lang_altertable.html   lang_attach.html   lang_createindex.html   lang_createtable.html   lang_createtrigger.html   lang_createview.html   lang_delete.html   lang_expr.html   lang_insert.html   lang_returning.html   lang_select.html   lang_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   lang_with.html#recursivecte   partialindex.html   releaselog/3_35_3.html   releaselog/3_35_4.html   releaselog/3_35_5.html

signed-number:#

Used by:   column-constraint   pragma-value   type-name\ See also:   lang_aggfunc.html   lang_altertable.html   lang_attach.html   lang_createindex.html   lang_createtable.html   lang_createtrigger.html   lang_createview.html   lang_delete.html   lang_expr.html   lang_insert.html   lang_returning.html   lang_select.html   lang_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html   pragma.html#syntax

simple-function-invocation:#

\ References:   expr\ See also:   lang_corefunc.html   lang_expr.html#*funcinexpr

simple-select-stmt:#

\ References:   common-table-expression   expr   ordering-term   select-core\ See also:   lang_select.html#simpleselect

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

sql-stmt-list:#

\ References:   sql-stmt\ See also:   lang.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#primkeyconst   lang_createtable.html#tablecoldef   lang_createtable.html#uniqueconst

table-options:#

Used by:   create-table-stmt\ See also:   lang_createtable.html

table-or-subquery:#

Used by:   join-clause   select-core   select-stmt   update-stmt   update-stmt-limited\ References:   expr   join-clause   select-stmt\ See also:   lang_aggfunc.html   lang_altertable.html   lang_attach.html   lang_createindex.html   lang_createtable.html   lang_createtrigger.html   lang_createview.html   lang_delete.html   lang_expr.html   lang_insert.html   lang_returning.html   lang_select.html   lang_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

type-name:#

Used by:   column-def   expr\ References:   signed-number\ See also:   lang_aggfunc.html   lang_altertable.html   lang_attach.html   lang_createindex.html   lang_createtable.html   lang_createtrigger.html   lang_createview.html   lang_delete.html   lang_expr.html   lang_insert.html   lang_returning.html   lang_select.html   lang_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

update-stmt:#

Used by:   create-trigger-stmt   sql-stmt\ References:   column-name-list   common-table-expression   expr   join-clause   qualified-table-name   returning-clause   table-or-subquery\ See also:   lang_createtrigger.html   lang_update.html

update-stmt-limited:#

Used by:   sql-stmt\ References:   column-name-list   common-table-expression   expr   join-clause   ordering-term   qualified-table-name   returning-clause   table-or-subquery\ See also:   lang_update.html#upfrom

upsert-clause:#

Used by:   insert-stmt\ References:   column-name-list   expr   indexed-column\ See also:   lang_createtrigger.html   lang_insert.html   lang_upsert.html

vacuum-stmt:#

Used by:   sql-stmt\ See also:   lang_vacuum.html

window-defn:#

Used by:   select-core   select-stmt   window-function-invocation\ References:   expr   frame-spec   ordering-term\ See also:   lang_aggfunc.html   lang_altertable.html   lang_attach.html   lang_createindex.html   lang_createtable.html   lang_createtrigger.html   lang_createview.html   lang_delete.html   lang_expr.html   lang_insert.html   lang_returning.html   lang_select.html   lang_select.html#compound   lang_select.html#simpleselect   lang_update.html   lang_upsert.html   lang_with.html   partialindex.html

window-function-invocation:#

\ References:   expr   filter-clause   window-defn\ See also:   lang_expr.html#*funcinexpr

with-clause:#

\ References:   cte-table-name   select-stmt\ See also:   lang_with.html