sqlANYsqliteforeign_keys
sql
PRAGMA foreign_keys = ON;Foreign key enforcement is connection-specific and should usually be enabled explicitly by applications.
SQLite PRAGMA and Administration Cheatsheet
High-signal PRAGMA commands for foreign keys, cache, synchronous settings, page size, temp storage, health checks, and general SQLite administration.
Export
Copy the compact sheet, download it, or print it.
Download
`D` dense toggle · `C` copy all
Integrity and connection behavior
Enable important safety settings and inspect database health.
sqlANYsqliteforeign_keysinspect
sql
PRAGMA foreign_keys;Useful when debugging unexpected orphan rows or migration behavior.
sqlANYsqliteforeign_key_check
sql
PRAGMA foreign_key_check;A great migration verification step.
sqlANYsqlitequick_check
sql
PRAGMA quick_check;Faster than a full integrity check and handy for routine validation.
Performance and file settings
Inspect or tune journaling, cache, and storage behavior.
sqlANYsqlitepage_size
sql
PRAGMA page_size;Page size is part of the file format and relevant for some performance and storage investigations.
sqlANYsqlitecache_sizememory
sql
PRAGMA cache_size = -20000;Negative values are interpreted as kibibytes, making sizing easier in some deployments.
sqlANYsqlitesynchronous
sql
PRAGMA synchronous = NORMAL;A common setting in WAL mode when balancing performance and durability.
sqlANYsqlitetemp_store
sql
PRAGMA temp_store = MEMORY;Can help workloads that build temporary btrees, sorts, or transient intermediate results.
sqlANYsqliteuser_versionmigrations
sql
PRAGMA user_version;
PRAGMA user_version = 12;A simple and popular migration bookkeeping mechanism in SQLite apps.
More in SQLite
SQLite Triggers, Views, and Generated Columns Cheatsheet
CREATE VIEW, CREATE TRIGGER, audit logging, derived values, generated columns, and automation patterns in SQLite.
SQLite Full-Text Search (FTS5) Cheatsheet
FTS5 virtual tables, MATCH queries, prefix search, phrase search, bm25 ranking, snippets, and highlighting patterns for SQLite search features.
SQLite JSON Functions Cheatsheet
json_extract, json_set, json_each, JSON operators, generated columns, and practical JSON query/update patterns in SQLite.
SQLite Import, Export, and Backup Cheatsheet
CSV import/export, SQL dumps, VACUUM INTO, backup copies, and repeatable data movement patterns for SQLite databases.
SQLite Transactions, WAL, and Locking Cheatsheet
BEGIN modes, COMMIT and ROLLBACK, savepoints, WAL mode, busy timeouts, and concurrency patterns for SQLite applications.
SQLite Indexes and Query Planner Cheatsheet
CREATE INDEX patterns, covering and partial indexes, EXPLAIN QUERY PLAN, ANALYZE, and practical tuning tips for SQLite queries.