Report rows that violate FK constraints.
Section: Integrity and connection behavior
Find foreign key violations
sql
sql
PRAGMA foreign_key_check;Explanation
A great migration verification step.
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.