sqlite-foreign-key-check · shipping · also PRAGMA foreign_key_check

SQLite foreign_key_check

SQLite foreign_key_check reports violations of foreign-key references declared in a database schema.

Related Observatory article: SQLite foreign_key_check on hesela.com

Validation and enforcement are separate operations. Enabling foreign_keys inside a transaction does not change enforcement; query its effective value outside the transaction. [1]

A nullable reference can contain NULL without violating its foreign key. A reference to an unintended but existing parent also passes the measured schema while failing the fixture's owner requirement. [2] [3]

Relations

related

sqlite-integrity-check, backup-verification, sqlite-online-backup

Citations

1. SQLite PRAGMA foreign_keys and foreign_key_check (accessed 2026-10-17)
2. SQLite Foreign Key Support (accessed 2026-10-17)
3. Hesela: executed SQLite validation-boundary cases (accessed 2026-10-17)

JSON: /data/terms/sqlite-foreign-key-check.json