Syntax Diagrams For SQLite

SQLite 语法图

sql-stmt-list:

参考: sql-stmt

另请参阅：lang.html

sql-stmt:

使用者: sql-stmt-list

参考：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

另请参阅：lang.html lang_explain.html

alter-table-stmt:

使用者：sql-stmt

参考文献：column-def

另请参阅：lang_altertable.html

analyze-stmt:

使用者：sql-stmt

另请参阅：lang_analyze.html

attach-stmt:

使用者：sql-stmt

参考文献：expr

另请参阅：lang_attach.html

begin-stmt:

使用者：sql-stmt

另请参阅：lang_transaction.html

commit-stmt:

使用者：sql-stmt

另请参阅：lang_transaction.html

rollback-stmt:

使用者：sql-stmt

另请参阅：lang_savepoint.html lang_transaction.html

savepoint-stmt:

使用者：sql-stmt

另请参阅：lang_savepoint.html

release-stmt:

使用者：sql-stmt

另请参阅：lang_savepoint.html

create-index-stmt:

使用者：sql-stmt

参考：expr indexed-column

另请参阅：lang_createindex.html partialindex.html

indexed-column:

使用者：create-index-stmt table-constraint

参考：expr

另请参阅：lang_createindex.html lang_createtable.html lang_createtable.html＃primkeyconst lang_createtable.html＃uniqueconst partialindex.html

create-table-stmt:

使用者：sql-stmt

引用：column-def select-stmt table-constraint

另请参阅：lang_createtable.html

column-def:

使用者：alter-table-stmt create-table-stmt

参考：column-constraint type-name

另请参阅：lang_altertable.html lang_createtable.html lang_createtable.html＃tablecoldef

type-name:

使用者：column-def expr

参考文献：signed-number

另见：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_select.html lang_select.html＃compound lang_select.html＃simpleselect lang_update.html lang_with.html partialindex html

column-constraint:

使用者：column-def

引用：conflict-clause expr foreign-key-clause literal-value signed-number

另请参阅：lang_altertable.html lang_createtable.html lang_createtable.html＃tablecoldef

signed-number:

使用者：column-constraint pragma-value type-name

table-constraint:

使用者：create-table-stmt

参考：conflict-clause expr foreign-key-clause indexed-column

另见：lang_createtable.html lang_createtable.html＃primkeyconst lang_createtable.html＃tablecoldef lang_createtable.html＃uniqueconst

foreign-key-clause:

用于：column-constraint table-constraint

另请参阅：lang_altertable.html lang_createtable.html

conflict-clause:

使用者：column-constraint table-constraint

另请参阅：lang_altertable.html lang_conflict.html lang_createtable.html lang_createtable.html＃notnullconst

create-trigger-stmt:

使用者：sql-stmt

参考：delete-stmt expr insert-stmt select -stmt update-stmt

另请参阅：lang_createtrigger.html

create-view-stmt:

使用者：sql-stmt

参考：select-stmt

另请参阅：lang_createview.html

create-virtual-table-stmt:

使用者：sql-stmt

另请参阅：lang_createvtab.html

with-clause:

使用者：delete-stmt delete-stmt-limited insert-stmt update-stmt update-stmt-limited

参考文献：cte-table-name select-stmt

另请参阅：lang_createtrigger.html lang_delete.html lang_insert.html lang_update.html lang_with.html

cte-table-name:

使用者：recursive-cte with-clause

另请参阅：lang_createtrigger.html lang_delete.html lang_insert.html lang_update.html lang_with.html lang_with.html＃recursivecte

recursive-cte:

References: cte-table-name

另见：lang_with.html＃recursivecte

common-table-expression:

使用者：compound-select-stmt factored-select-stmt select-stmt simple-select-stmt

参考：select-stmt

delete-stmt:

使用者：create-trigger-stmt sql-stmt

参考文献：expr qualified-table-name with-clause

另请参阅：lang_createtrigger.html lang_delete.html

delete-stmt-limited:

使用者：sql-stmt

参考文献：expr order-term qualified-table-name with-clause

另请参阅：lang_delete.html

detach-stmt:

使用者：sql-stmt

另请参阅：lang_detach.html

drop-index-stmt:

使用者：sql-stmt

另请参阅：lang_dropindex.html

drop-table-stmt:

使用者：sql-stmt

另请参阅：lang_droptable.html

drop-trigger-stmt:

使用者：sql-stmt

另请参阅：lang_droptrigger.html

drop-view-stmt:

使用者：sql-stmt

另请参阅：lang_dropview.html

expr:

使用者：attach-stmt column-constraint compound-select-stmt create-index-stmt create-trigger-stmt delete-stmt delete-stmt-limited factored-select-stmt indexed-column insert-stmt join-constraint ordering-term result-column select-core select-stmt simple-select-stmt table-constraint table-or-subquery update-stmt update-stmt-limited

引用：literal-value raise-function select-stmt type-name

raise-function:

使用者：expr

另请参阅：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_select.html lang_select.html＃compound lang_select.html＃simpleselect lang_update。 html lang_with.html partialindex.html

literal-value:

使用者：column-constraint expr

numeric-literal:

另请参阅：lang_expr.html＃litvalue

insert-stmt:

使用者：create-trigger-stmt sql-stmt

参考：expr select-stmt with-clause

另请参阅：lang_createtrigger.html lang_insert.html

pragma-stmt:

使用者：sql-stmt

参考文献：pragma-value

另请参阅：pragma.html#syntax

pragma-value:

使用者：pragma-stmt

参考文献：signed-number

另请参阅：pragma.html#syntax

reindex-stmt:

使用者：sql-stmt

另请参阅：lang_reindex.html

select-stmt:

使用方法：common-table-expression create-table-stmt create-trigger-stmt create-view -stmt expr insert-stmt sql -stmt table-or-subquery with-clause

参考：common-table-expression compound-operator expr join-clause ordering-term result-column table-or-subquery

另请参见： 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_select.html lang_select.html#compound lang_select.html#simpleselect lang_update.html lang_with.html lang_with.html#recursivecte partialindex.html

join-clause:

使用者：select-core select -stmt table-or-subquery

引用：join-constraint join-operator table-or-subquery

select-core:

使用者：compound-select-stmt factored-select-stmt simple-select-stmt

参考：expr join-clause result-column table-or-subquery

另请参阅：lang_select.html lang_select.html＃compound lang_select.html＃simpleselect

factored-select-stmt:

参考文献：common-table-expression compound-operator expr ordering-term select-core

另请参阅：lang_select.html

simple-select-stmt:

参考文献：common-table-expression expr order-term select-core

另请参阅：lang_select.html＃simpleselect

compound-select-stmt:

参考文献：common-table-expression expr order-term select-core

另请参阅：lang_select.html＃compound

table-or-subquery:

使用者：join-clause select-core select-stmt

引用：expr join-clause select-stmt

另见：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_select.html lang_select.html#compound lang_select.html#simpleselect lang_update.html lang_with.html partialindex.html

result-column:

使用者：select-core select-stmt

参考文献：expr

另见：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_select.html lang_select.html#compound lang_select.html#simpleselect lang_update.html lang_with.html partialindex.html

join-operator:

使用者：join-clause

另请参见：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_select.html lang_select.html#compound lang_select.html#fromclause lang_select.html#simpleselect lang_update.html lang_with.html partialindex.html

join-constraint:

使用者：join-clause

参考文献：expr

另请参见：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_select.html lang_select.html#compound lang_select.html#fromclause lang_select.html#simpleselect lang_update.html lang_with.html partialindex.html

ordering-term:

使用者：compound-select-stmt delete -stmt -restricored-select -stmt select -stmt simple-select-stmt update-stmt-limited

参考文献：expr

compound-operator:

使用者：factored-select-stmt select-stmt

另请参见：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_select.html lang_select.html#compound lang_select.html#simpleselect lang_update.html lang_with.html lang_with.html#recursivecte partialindex.html

update-stmt:

使用者：create-trigger-stmt sql-stmt

参考：column-name-list expr qualified-table-name with-clause

另请参阅：lang_createtrigger.html lang_update.html

column-name-list:

使用者：update-stmt update-stmt-limited

另请参阅：lang_createtrigger.html lang_update.html

update-stmt-limited:

使用者：sql-stmt

参考：column-name-list expr order-term qualified-table-name with-clause

另请参阅：lang_update.html

qualified-table-name:

使用者：delete -stmt delete -stmt -required -stmt update-stmt-limited

vacuum-stmt:

使用者：sql-stmt

Syntax Diagrams For SQLite

SQLite 语法图

sql-stmt-list:

sql-stmt:

alter-table-stmt:

analyze-stmt:

attach-stmt:

begin-stmt:

commit-stmt:

rollback-stmt:

savepoint-stmt:

release-stmt:

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:

create-virtual-table-stmt:

with-clause:

cte-table-name:

recursive-cte:

common-table-expression:

delete-stmt:

delete-stmt-limited:

detach-stmt:

drop-index-stmt:

drop-table-stmt:

drop-trigger-stmt:

drop-view-stmt:

expr:

raise-function:

literal-value:

numeric-literal:

insert-stmt:

pragma-stmt:

pragma-value:

reindex-stmt:

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:

comment-syntax: