W3cubDocs
/
SQLite
W3cubTools
Cheatsheets
About
3.44.2
SQLite
392
C Interface
52
C Interface: Session Module
1
CLI
2
Database File Format
2
Datatypes
1
Dynamic Memory Allocation
1
Foreign Key Constraints
2
Full-Text Search
13
Geopoly
1
How To Corrupt
1
JSON
149
Language
1
Limits
1
Locking and Concurrency
152
Miscellaneous
1
PRAGMA Statements
11
Query Planner
1
R*Tree Module
1
RBU Extension
72
Syntax Diagrams
SQLite Syntax: aggregate-function-invocation
SQLite Syntax: alter-table-stmt
SQLite Syntax: analyze-stmt
SQLite Syntax: attach-stmt
SQLite Syntax: begin-stmt
SQLite Syntax: column-constraint
SQLite Syntax: column-def
SQLite Syntax: column-name-list
SQLite Syntax: comment-syntax
SQLite Syntax: commit-stmt
SQLite Syntax: common-table-expression
SQLite Syntax: compound-operator
SQLite Syntax: compound-select-stmt
SQLite Syntax: conflict-clause
SQLite Syntax: create-index-stmt
SQLite Syntax: create-table-stmt
SQLite Syntax: create-trigger-stmt
SQLite Syntax: create-view-stmt
SQLite Syntax: create-virtual-table-stmt
SQLite Syntax: cte-table-name
SQLite Syntax: delete-stmt
SQLite Syntax: delete-stmt-limited
SQLite Syntax: detach-stmt
SQLite Syntax: drop-index-stmt
SQLite Syntax: drop-table-stmt
SQLite Syntax: drop-trigger-stmt
SQLite Syntax: drop-view-stmt
SQLite Syntax: expr
SQLite Syntax: factored-select-stmt
SQLite Syntax: filter-clause
SQLite Syntax: foreign-key-clause
SQLite Syntax: frame-spec
SQLite Syntax: function-arguments
SQLite Syntax: indexed-column
SQLite Syntax: insert-stmt
SQLite Syntax: join-clause
SQLite Syntax: join-constraint
SQLite Syntax: join-operator
SQLite Syntax: literal-value
SQLite Syntax: numeric-literal
SQLite Syntax: ordering-term
SQLite Syntax: over-clause
SQLite Syntax: pragma-stmt
SQLite Syntax: pragma-value
SQLite Syntax: qualified-table-name
SQLite Syntax: raise-function
SQLite Syntax: recursive-cte
SQLite Syntax: reindex-stmt
SQLite Syntax: release-stmt
SQLite Syntax: result-column
SQLite Syntax: returning-clause
SQLite Syntax: rollback-stmt
SQLite Syntax: savepoint-stmt
SQLite Syntax: select-core
SQLite Syntax: select-stmt
SQLite Syntax: signed-number
SQLite Syntax: simple-function-invocation
SQLite Syntax: simple-select-stmt
SQLite Syntax: sql-stmt
SQLite Syntax: sql-stmt-list
SQLite Syntax: table-constraint
SQLite Syntax: table-options
SQLite Syntax: table-or-subquery
SQLite Syntax: type-name
SQLite Syntax: update-stmt
SQLite Syntax: update-stmt-limited
SQLite Syntax: upsert-clause
SQLite Syntax: vacuum-stmt
SQLite Syntax: window-defn
SQLite Syntax: window-function-invocation
SQLite Syntax: with-clause
Syntax Diagrams For SQLite
1
Tcl Interface
2
Virtual Table Mechanism
11
Write-Ahead Logging
type-name
name
(
signed-number
,
signed-number
)
(
signed-number
)
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_update.html
lang_upsert.html
lang_with.html
partialindex.html
SQLite is in the Public Domain.
https://sqlite.org/syntax/type-name.html