SET CONSTRAINTS() SQL Commands SET CONSTRAINTS()NAME
SET CONSTRAINTS - Set the constraint mode of the current SQL-transac‐
tion
SYNOPSIS
SET CONSTRAINTS { ALL | constraint [, ...] } { DEFERRED | IMMEDIATE }
DESCRIPTION
SET CONSTRAINTS sets the behavior of constraint evaluation in the cur‐
rent transaction. In IMMEDIATE mode, constraints are checked at the end
of each statement. In DEFERRED mode, constraints are not checked until
transaction commit.
Upon creation, a constraint is always give one of three characteris‐
tics: INITIALLY DEFERRED, INITIALLY IMMEDIATE DEFERRABLE, or INITIALLY
IMMEDIATE NOT DEFERRABLE. The third class is not affected by the SET
CONSTRAINTS command.
Currently, only foreign key constraints are affected by this setting.
Check and unique constraints are always effectively initially immediate
not deferrable.
COMPATIBILITY
SQL92, SQL99
SET CONSTRAINT is defined in SQL92 and SQL99.
SQL - Language Statements 29 March 2001 SET CONSTRAINTS()
