sqlite3_blob_open()

 ... 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 blob is being opened ... 

 ... Unfortunately, once humpty-dumpty falls off the wall, it is generally not possible to put him back together again. (22) Does SQLite support foreign keys? As of version 3.6.19 (2009-10-14), SQLite supports foreign key constraints. But ... 

 ... EXCLUSIVE EXISTS EXPLAIN FAIL FILTER FIRST FOLLOWING FOR FOREIGN FROM FULL GENERATED GLOB GROUP GROUPS HAVING IF IGNORE IMMEDIATE IN INDEX INDEXED INITIALLY INNER INSERT INSTEAD INTERSECT INTO IS ISNULL JOIN KEY LAST LEFT LIKE LIMIT MATCH MATERIALIZED NATURAL NO ... 

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 ... 

sqlite3_changes(), sqlite3_changes64()

 ... Only changes made directly by the INSERT, UPDATE or DELETE statement are considered - auxiliary changes caused by triggers, foreign key actions or REPLACE constraint resolution are not counted. Changes to a view that are intercepted by INSTEAD OF triggers are ... 

PRAGMA foreign_keys PRAGMA foreign_keys; PRAGMA foreign_keys = boolean; Query, set, or clear the enforcement of foreign key constraints. This pragma is a no-op within a transaction; foreign key constraint enforcement may only be enabled or disabled when there is no pending BEGIN ... 

 ... The conflicting row in this case is the database row with the matching primary key. SQLITE_CHANGESET_FOREIGN_KEY If foreign key handling is enabled, and applying a changeset leaves the database in a state containing foreign key violations, the conflict handler is ... 

 ... A "uniqueness constraint" is an explicit UNIQUE or PRIMARY KEY constraint within the CREATE TABLE statement, or a unique index. UPSERT does not intervene for failed NOT NULL, CHECK, or foreign key constraints or for constraints that are implemented using ... 

2. STRICT Tables  ... 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 work the same. Indexes work the same. AUTOINCREMENT works the same ... 

SQLITE_DBSTATUS_LOOKASIDE_USED, SQLITE_DBSTATUS_CACHE_USED, SQLITE_DBSTATUS_SCHEMA_USED, SQLITE_DBSTATUS_STMT_USED, SQLITE_DBSTATUS_LOOKASIDE_HIT, SQLITE_DBSTATUS_LOOKASIDE_MISS_SIZE ... 

 ... SQLITE_DBSTATUS_DEFERRED_FKS This parameter returns zero for the current value if and only if all foreign key constraints (deferred or immediate) have been resolved. The highwater mark is always 0. See also lists of Objects, Constants, and Functions.