W3cubDocs

/SQLite

Syntax Diagrams For SQLite

sql-stmt-list:



References: sql-stmt
See also: lang.html

sql-stmt:

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
References: expr
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:

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:

indexed-column:

create-table-stmt:

column-def:

type-name:

column-constraint:

signed-number:

table-constraint:

foreign-key-clause:

conflict-clause:

create-trigger-stmt:

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

with-clause:

cte-table-name:

recursive-cte:

common-table-expression:

delete-stmt:

delete-stmt-limited:

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:

raise-function:

literal-value:

numeric-literal:

insert-stmt:

upsert-clause:

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:

join-clause:

select-core:

factored-select-stmt:

simple-select-stmt:

compound-select-stmt:

table-or-subquery:

result-column:

join-operator:

join-constraint:

ordering-term:

compound-operator:

update-stmt:

column-name-list:

update-stmt-limited:

qualified-table-name:

vacuum-stmt:


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

comment-syntax:



See also: lang_comment.html

filter:

window-defn:

frame-spec:

function-invocation:



References: expr

window-function-invocation:



References: expr filter window-defn

SQLite is in the Public Domain.
https://sqlite.org/syntaxdiagrams.html