SQLite PRAGMA and Administration Cheatsheet/Enable foreign key enforcement

Turn on FK checks for the current connection.

Section: Integrity and connection behavior

Enable foreign key enforcement

sql
sql
PRAGMA foreign_keys = ON;
Explanation

Foreign key enforcement is connection-specific and should usually be enabled explicitly by applications.

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Related commands

Same sheet · prioritizing Integrity and connection behavior
Check current foreign key setting
Read whether FK enforcement is enabled.
OpenIn sheetsqlsame section
Find foreign key violations
Report rows that violate FK constraints.
OpenIn sheetsqlsame section
Run a quick integrity check
Perform a lighter-weight consistency scan.
OpenIn sheetsqlsame section
Inspect page size
Read the database page size.
OpenIn sheetsql1 tag match
Set cache size
Adjust the number of pages or kibibytes used for page cache.
OpenIn sheetsql1 tag match
Set synchronous mode
Control durability vs speed tradeoffs.
OpenIn sheetsql1 tag match