Small. Fast. Reliable.
Choose any three.

table-constraint

CONSTRAINT name PRIMARY KEY ( indexed-column ) conflict-clause , UNIQUE CHECK ( expr ) FOREIGN KEY ( column-name ) foreign-key-clause ,

Used by:   create-table-stmt

References:   conflict-clause   expr   foreign-key-clause   indexed-column

See also:   lang_createtable.html