ignoreCheckConstraints

Queries or sets the ignore_check_constraints flag.

When set to true, the enforcement of CHECK constraints is disabled for this database connection. When set to false (the default), CHECK constraints are enforced.

Disabling CHECK constraints can be useful for bulk data loading or for restoring a database from a backup where the data is already known to be valid. However, it should be used with caution as it can allow invalid data to be inserted or updated, potentially leading to data corruption.

This pragma does not affect FOREIGN KEY, PRIMARY KEY, or NOT NULL constraints.

See also