SQLITE_ACCESS_EXISTS, SQLITE_ACCESS_READWRITE, SQLITE_ACCESS_READ

 ... The SQLITE_ACCESS_READWRITE constant is currently used only by the temp_store_directory pragma, though this could change in a future release of SQLite. With SQLITE_ACCESS_READ, the xAccess method checks whether the file is readable. The SQLITE_ACCESS_READ constant is currently unused, though it ... 

sqlite3_wal_autocheckpoint()

 ... The wal_autocheckpoint pragma can be used to invoke this interface from SQL. Checkpoints initiated by this mechanism are PASSIVE. Every new database connection defaults to having the auto-checkpoint enabled with a threshold of 1000 or SQLITE_DEFAULT_WAL_AUTOCHECKPOINT pages. The use ... 

SQLITE_DBCONFIG_MAINDBNAME, SQLITE_DBCONFIG_LOOKASIDE, SQLITE_DBCONFIG_ENABLE_FKEY, SQLITE_DBCONFIG_ENABLE_TRIGGER, SQLITE_DBCONFIG_ENABLE_FTS3_TOKENIZER, SQLITE_DBCONFIG_ENABLE_LOAD_EXTENSION ... 

 ... The PRAGMA writable_schema=ON statement. The PRAGMA journal_mode=OFF statement. The PRAGMA schema_version=N statement. Writes to the sqlite_dbpage virtual table. Direct writes to shadow tables. SQLITE_DBCONFIG_WRITABLE_SCHEMA The SQLITE_DBCONFIG_WRITABLE_SCHEMA option activates or deactivates the "writable_schema" flag. This has the same ... 

 ... DROP TRIGGER DROP VIEW END TRANSACTION EXPLAIN expression INDEXED BY INSERT JSON functions keywords math functions ON CONFLICT clause PRAGMA REINDEX RELEASE SAVEPOINT REPLACE RETURNING clause ROLLBACK TRANSACTION SAVEPOINT SELECT UPDATE UPSERT VACUUM window functions WITH clause The routines sqlite3_prepare_v2 ... 

2. Enabling Foreign Key Support  ... sqlite> PRAGMA foreign_keys; 0 sqlite> PRAGMA foreign_keys = ON; sqlite> PRAGMA foreign_keys; 1 sqlite> PRAGMA foreign_keys = OFF; sqlite> PRAGMA foreign_keys; 0 Tip: If the command "PRAGMA foreign_keys" returns no data instead of a single row containing "0" or "1", then the ... 

 ... Used by:   sql-stmt References:   pragma-value See also:   pragma.html#syntax pragma-value: Used by:   pragma-stmt References:   signed-number See also:   pragma.html#syntax qualified-table ... 

5. Determining If An Existing Table Is WITHOUT ROWID A WITHOUT ROWID table returns the same content for PRAGMA table_info and PRAGMA table_xinfo as does an ordinary table. But unlike an ordinary table, a WITHOUT ROWID also responds to the PRAGMA index_info command. The PRAGMA index_info on a WITHOUT ... 

sqlite3_wal_hook()

 ... Note that the sqlite3_wal_autocheckpoint() interface and the wal_autocheckpoint pragma both invoke sqlite3_wal_hook() and will overwrite any prior sqlite3_wal_hook() settings. See also lists of Objects, Constants, and Functions.

sqlite3_limit()

 ... The size of the database created by an untrusted script can be contained using the max_page_count PRAGMA. New run-time limit categories may be added in future releases. See also lists of Objects, Constants, and Functions.

2. Virtual Tables  ... pragma Built-in table-valued functions that return the results of PRAGMA statements for use within ordinary SQL queries. RTree An implementation of the Guttmann R*Tree spatial index idea. spellfix1 A virtual table that implements a spelling correction engine ...