integrityCheck

Performs a comprehensive integrity check of the database or a specific table.

This pragma runs a thorough check of the entire database structure, including b-tree integrity, index consistency, and constraint satisfaction. It is a powerful tool for detecting database corruption. The check can be time-consuming for large databases.

• If the check is successful, the returned cursor will contain a single row with the text "ok".

• If corruption is found, the cursor will contain multiple rows, each describing a specific error that was detected.

For a faster, less thorough check, see quickCheck. A convenience function, isIntegrityCheckOK, is provided to simplify checking for the "ok" result.

Parameters

See also