STRICT table

A SQLite table declared with the STRICT keyword, which rejects any value that does not match its column's declared type.

In more detail

STRICT tables were added in SQLite 3.37 and make SQLite behave like a server database for types. Their columns must use one of the basic type names, such as INTEGER, REAL, TEXT or BLOB. Write STRICT when you want mistakes refused rather than stored.

Example

CREATE TABLE tight (n INTEGER) STRICT;

Related terms

Taught in

References