W3cubDocs
/
SQLite
W3cubTools
Cheatsheets
About
column-constraint
CONSTRAINT
name
PRIMARY
KEY
DESC
conflict-clause
AUTOINCREMENT
ASC
NOT
NULL
conflict-clause
UNIQUE
conflict-clause
CHECK
(
expr
)
DEFAULT
(
expr
)
literal-value
signed-number
COLLATE
collation-name
foreign-key-clause
GENERATED
ALWAYS
AS
(
expr
)
VIRTUAL
STORED
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
SQLite is in the Public Domain.
https://sqlite.org/syntax/column-constraint.html