Read whether FK enforcement is enabled.
Section: Integrity and connection behavior
Check current foreign key setting
sql
sql
PRAGMA foreign_keys;Explanation
Useful when debugging unexpected orphan rows or migration behavior.
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
Enable foreign key enforcement
Turn on FK checks for the current connection.
Set cache size
Adjust the number of pages or kibibytes used for page cache.