Small. Fast. Reliable.
Choose any three.

About Sitemap Documentation Download License News Developers Support

# SQLite SQL Language Syntax Diagrams

#### sql-stmt-list:

> References: sql-stmt

#### 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

#### alter-table-stmt:

> Used by: sql-stmt
> References: column-def

#### analyze-stmt:

> Used by: sql-stmt

#### attach-stmt:

> Used by: sql-stmt

#### begin-stmt:

> Used by: sql-stmt

#### commit-stmt:

> Used by: sql-stmt

#### rollback-stmt:

> Used by: sql-stmt

#### savepoint-stmt:

> Used by: sql-stmt

#### release-stmt:

> Used by: sql-stmt

#### create-index-stmt:

> Used by: sql-stmt
> References: indexed-column

#### indexed-column:

> Used by: create-index-stmt table-constraint

#### create-table-stmt:

> Used by: sql-stmt
> References: column-def select-stmt table-constraint

#### column-def:

> Used by: alter-table-stmt create-table-stmt
> References: column-constraint type-name

#### type-name:

> Used by: column-def expr
> References: signed-number

#### column-constraint:

> Used by: column-def
> References: conflict-clause expr foreign-key-clause literal-value signed-number

#### signed-number:

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

#### table-constraint:

> Used by: create-table-stmt
> References: conflict-clause expr foreign-key-clause indexed-column

#### foreign-key-clause:

> Used by: column-constraint table-constraint

#### conflict-clause:

> Used by: column-constraint table-constraint

#### create-trigger-stmt:

> Used by: sql-stmt
> References: delete-stmt expr insert-stmt select-stmt update-stmt

#### create-view-stmt:

> Used by: sql-stmt
> References: select-stmt

#### create-virtual-table-stmt:

> Used by: sql-stmt

#### delete-stmt:

> Used by: create-trigger-stmt sql-stmt
> References: expr qualified-table-name

#### delete-stmt-limited:

> Used by: sql-stmt
> References: expr ordering-term qualified-table-name

#### detach-stmt:

> Used by: sql-stmt

#### drop-index-stmt:

> Used by: sql-stmt

#### drop-table-stmt:

> Used by: sql-stmt

#### drop-trigger-stmt:

> Used by: sql-stmt

#### drop-view-stmt:

> Used by: sql-stmt

#### 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

#### raise-function:

> Used by: expr

#### literal-value:

> Used by: column-constraint expr

#### insert-stmt:

> Used by: create-trigger-stmt sql-stmt
> References: expr select-stmt

#### pragma-stmt:

> Used by: sql-stmt
> References: pragma-value

#### pragma-value:

> Used by: pragma-stmt
> References: signed-number

#### reindex-stmt:

> Used by: sql-stmt

#### 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

#### select-core:

> Used by: select-stmt
> References: expr join-source ordering-term result-column

#### result-column:

> Used by: select-core
> References: expr

#### join-source:

> Used by: select-core single-source
> References: join-constraint join-op single-source

#### single-source:

> Used by: join-source
> References: join-source select-stmt

#### join-op:

> Used by: join-source

#### join-constraint:

> Used by: join-source
> References: expr

#### ordering-term:

> Used by: delete-stmt-limited select-core select-stmt update-stmt-limited
> References: expr

#### compound-operator:

> Used by: select-stmt

#### update-stmt:

> Used by: create-trigger-stmt sql-stmt
> References: expr qualified-table-name

#### update-stmt-limited:

> Used by: sql-stmt
> References: expr ordering-term qualified-table-name

#### qualified-table-name:

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

#### vacuum-stmt:

> Used by: sql-stmt

#### comment-syntax:

This page last modified 2008/10/09 15:16:24 UTC