Name

quick_check — Initiate a partial database file integrity verification

Common Usage

PRAGMA [database.]quick_check;
PRAGMA [database.]quick_check( max_errors );

Description

The quick_check pragma runs an abbreviated integrity check on a database file. The quick_check pragma is identical to the integrity_check pragma, except that it does not verify that the contents of each index is in sync with its source-table data. By skipping this test, the time required to do the integrity test is greatly reduced.

See Also

integrity_check

Get Using SQLite now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.