PRAGMA Statements The PRAGMA statement is an SQL extension specific to SQLite and used to modify the operation of the SQLite library or to query the SQLite library for internal (non-table) data. The PRAGMA statement is issued using the ... 

 ... SQLITE_DROP_VIEW, SQLITE_INSERT, SQLITE_PRAGMA, SQLITE_READ, SQLITE_SELECT, SQLITE_TRANSACTION ... 

The sqlite3_set_authorizer() interface registers a callback function that is invoked to authorize certain SQL statement actions. The second parameter to the callback is an integer code that specifies what action is being authorized. These are the integer action codes that ... 

 ... Periodically run "PRAGMA optimize" The PRAGMA optimize command will automatically run ANALYZE when needed. Suggested use: Applications with short-lived database connections should run "PRAGMA optimize;" once, just prior to closing each database connection. Applications that use long-lived database ... 

 ... Some PRAGMA statements do their work during sqlite3_prepare() rather than during sqlite3_step(). Those PRAGMA statements are unaffected by EXPLAIN. They operate the same with or without the EXPLAIN prefix. The set of PRAGMA statements that are unaffected by EXPLAIN can ... 

 ... The temp_store_directory pragma may modify this variable and cause it to point to memory obtained from sqlite3_malloc. Furthermore, the temp_store_directory pragma always assumes that any string that this variable points to is held in memory obtained from sqlite3_malloc and the ... 

 ... The data_store_directory pragma may modify this variable and cause it to point to memory obtained from sqlite3_malloc. Furthermore, the data_store_directory pragma always assumes that any string that this variable points to is held in memory obtained from sqlite3_malloc and the ... 

6. Controlling Checksum Verification The cksumvfs extension implements a new PRAGMA statement that can be used to disable, re-enable, or query the status of checksum verification: PRAGMA checksum_verification; -- query status PRAGMA checksum_verification=OFF; -- disable verification PRAGMA checksum_verification=ON; -- re-enable verification The "checksum_verification ... 

SQLITE_SYNC_NORMAL, SQLITE_SYNC_FULL, SQLITE_SYNC_DATAONLY

 ... Do not confuse the SQLITE_SYNC_NORMAL and SQLITE_SYNC_FULL flags with the PRAGMA synchronous=NORMAL and PRAGMA synchronous=FULL settings. The synchronous pragma determines when calls to the xSync VFS method occur and applies uniformly across all platforms. The SQLITE_SYNC_NORMAL and SQLITE_SYNC_FULL ... 

sqlite3_total_changes(), sqlite3_total_changes64()

 ... the sqlite3_changes() interface the count_changes pragma the changes() SQL function the data_version pragma the SQLITE_FCNTL_DATA_VERSION file control See also lists of Objects, Constants, and Functions.

sqlite3_data_count()

 ... The sqlite3_data_count(P) will return non-zero if previous call to sqlite3_step(P) returned SQLITE_ROW, except in the case of the PRAGMA incremental_vacuum where it always returns zero since each step of that multi-step pragma returns 0 columns of ...