... ABORT ACTION ADD AFTER ALL ALTER ALWAYS ANALYZE AND AS ASC ATTACH AUTOINCREMENT BEFORE BEGIN BETWEEN BY CASCADE CASE CAST CHECK COLLATE COLUMN COMMIT CONFLICT CONSTRAINT CREATE CROSS CURRENT CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP DATABASE DEFAULT DEFERRABLE DEFERRED DELETE DESC DETACH DISTINCT ... 

4. The Opcodes  ... FkCheck Halt with an SQLITE_CONSTRAINT error if there are any unresolved foreign key constraint violations. If there are no foreign key constraint violations, this is a no-op. FK constraint violations are also checked when the prepared statement exits. This ... 

1. Overview  ... Swarmvtab efficiently handles range and equality constraints on the rowid (or other INTEGER PRIMARY KEY) field only. If a query does not contain such a constraint, then swarmvtab finds the results by opening each database in turn and linearly scanning ... 

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.

1.8. OR-Connected Terms In The WHERE Clause Multi-column indices only work if the constraint terms in the WHERE clause of the query are connected by AND. So Idx3 and Idx4 are helpful when the search is for items that are both Oranges and grown in California ... 

4. Options To Set Default Parameter Values  ... SQLITE_DEFAULT_FOREIGN_KEYS=<0 or 1> This macro determines whether enforcement of foreign key constraints is enabled or disabled by default for new database connections. Each database connection can always turn enforcement of foreign key constraints on and off and ... 

 ... This is the only difference between a USING clause and its equivalent ON constraint. If the NATURAL keyword is in the join-operator then an implicit USING clause is added to the join-constraints. The implicit USING clause contains each ... 

 ... But on systems that impose 8+3 filename constraints, the auxiliary files do not fit the 8+3 format even though the original database file does. Changing Filesystems The recommended fix for this problem is to select a different filesystem ... 

2.1. RBU Update Limitations  ... The RBU update will not detect or prevent foreign key or CHECK constraint violations. All RBU updates use the "OR ROLLBACK" constraint handling mechanism. The target database may not be in WAL mode. The target database may not contain indexes ... 

 ... The result of avg() is computed as total()/count() so all of the constraints that apply to total() also apply to avg(). count(X)count(*) The count(X) function returns a count of the number of times that X is ...