2. STRICT Tables  ... CHECK constraints work the same. NOT NULL constraints work the same. FOREIGN KEY constraints work the same. UNIQUE constraints work the same. DEFAULT clauses work the same. COLLATE clauses work the same. Generated columns work the same. ON CONFLICT clauses ... 

2.2. Capabilities  ... Generated columns may have NOT NULL, CHECK, and UNIQUE constraints, and foreign key constraints, just like ordinary columns. Generated columns can participate in indexes, just like ordinary columns. The expression of a generated column can refer to any of the ... 

4.1. Converting OR-connected constraint into an IN operator If a term consists of multiple subterms containing a common column name and separated by OR, like this: column = expr1 OR column = expr2 OR column = expr3 OR ... Then that term is rewritten as follows: column IN (expr1,expr2,expr3,...) The ... 

 ... Used by:   column-constraint   table-constraint See also:   lang_altertable.html   lang_conflict.html   lang_createtable.html   lang_createtable.html#notnullconst create-index-stmt: Used by:   sql-stmt References:  ... 

1.1. Limitations  ... CHECK constraints, FOREIGN KEY constraints, UNIQUE constraints, type constraints on STRICT tables - any of these might be violated in the recovered database. Content might be moved from one table into another. The recovery API does as good of a job ... 

6. Result Code Meanings  ... The maximum SQL statement length can be set at compile-time using SQLITE_MAX_SQL_LENGTH or at run-time using sqlite3_limit(db,SQLITE_LIMIT_SQL_LENGTH,...). (19) SQLITE_CONSTRAINT The SQLITE_CONSTRAINT error code means that an SQL constraint violation occurred while trying to process an SQL ... 

 ... Without the WHERE clause, the parser does not know if the token "ON" is part of a join constraint on the SELECT, or the beginning of the . INSERT INTO table DEFAULT VALUES; The third form of an INSERT statement is ... 

sqlite3_column_count()

 ... A SELECT statement will always have a positive sqlite3_column_count() but depending on the WHERE clause constraints and the table content, it might return no rows. See also: sqlite3_data_count() See also lists of Objects, Constants, and Functions.

2. Restrictions on the use of non-deterministic functions  ... In the expression of a CHECK constraint. In the WHERE clause of a partial index. In an expression used as part of an expression index. In the expression of a generated column. In the cases above, the values returned by ... 

 ... The PRIMARY KEY constraint for a rowid table (as long as it is not the true primary key or INTEGER PRIMARY KEY) is really the same thing as a UNIQUE constraint. Because it is not a true primary key, columns ...