... But enforcement of foreign key constraints is turned off by default (for backwards compatibility). To enable foreign key constraint enforcement, run PRAGMA foreign_keys=ON or compile with -DSQLITE_DEFAULT_FOREIGN_KEYS=1. (23) I get a compiler error if I use the SQLITE_OMIT_ ... 

4. Foreign Key Enforcement Is Off By Default SQLite has parsed foreign key constraints for time out of mind, but added the ability to actually enforce those constraints much later, with version 3.6.19 (2009-10-14). By the time foreign key constraint enforcement was added, there ... 

sqlite3_blob_open()

 ... BLOB value, Column zColumn is part of an index, PRIMARY KEY or UNIQUE constraint and the blob is being opened for read/write access, Foreign key constraints are enabled, column zColumn is part of a child key definition and the ... 

sqlite3_total_changes(), sqlite3_total_changes64()

 ... Changes made as part of foreign key actions are included in the count, but those made as part of REPLACE constraint resolution are not. Changes to a view that are intercepted by INSTEAD OF triggers are not counted. The sqlite3_total_changes ... 

 ... Other kinds of ALTER TABLE operations such as ALTER COLUMN, ADD CONSTRAINT, and so forth are omitted. Complete trigger support  FOR EACH ROW triggers are supported but not FOR EACH STATEMENT triggers. Writing to VIEWs  VIEWs in SQLite ... 

 ... DESC and COLLATE Partial indexes Indexes On Expressions Clustered indexes Covering indexes CHECK, UNIQUE, NOT NULL, and FOREIGN KEY constraints. ACID transactions using BEGIN, COMMIT, and ROLLBACK Nested transactions using SAVEPOINT, RELEASE, and ROLLBACK TO Subqueries, including correlated subqueries Up ... 

SQLITE_DETERMINISTIC, SQLITE_DIRECTONLY, SQLITE_SUBTYPE, SQLITE_INNOCUOUS, SQLITE_RESULT_SUBTYPE, SQLITE_SELFORDER1

 ... SQLITE_DIRECTONLY The SQLITE_DIRECTONLY flag means that the function may only be invoked from top-level SQL, and cannot be used in VIEWs or TRIGGERs nor in schema structures such as CHECK constraints, DEFAULT clauses, expression indexes, partial indexes, or generated ... 

2. Restrictions  ... Expressions may only be used in CREATE INDEX statements, not within UNIQUE or PRIMARY KEY constraints within the CREATE TABLE statement.

sqlite3_reset()

 ... return SQLITE_ROW but the overall statement might still fail and the sqlite3_reset(S) call might return SQLITE_BUSY if locking constraints prevent the database change from committing. Therefore, it is important that applications check the return code from sqlite3_reset(S) even ... 

PRAGMA defer_foreign_keys PRAGMA defer_foreign_keys PRAGMA defer_foreign_keys = boolean; When the defer_foreign_keys PRAGMA is on, enforcement of all foreign key constraints is delayed until the outermost transaction is committed. The defer_foreign_keys pragma defaults to OFF so that foreign key constraints are only deferred if ...