Name

ignore_check_constraints — Disable CHECK constraints

Common Usage

PRAGMA ignore_check_constraints;
PRAGMA ignore_check_constraints = switch;

Description

The ignore_check_constraints pragma controls the enforcement of CHECK constraints. CHECK constraints are defined in CREATE TABLE statements as arbitrary expressions that must be true before a row can be inserted or updated. If this pragma is set, this type of constraint is ignored. Turning this pragma back on will not verify existing rows.

This is an undocumented pragma.