Perform a lighter-weight consistency scan.

Section: Integrity and connection behavior

Run a quick integrity check

sql
sql
PRAGMA quick_check;
Explanation

Faster than a full integrity check and handy for routine validation.

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.
OpenIn sheetsqlsame section
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
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