Initially Deferred

A constraint mode starting each transaction with checking postponed until commit.

What is Initially Deferred in a relational database?

Initially Deferred — A constraint mode starting each transaction with checking postponed until commit.

ALTER TABLE enrollment
ADD CONSTRAINT enrollment_student_fk
FOREIGN KEY (student_id) REFERENCES student (student_id)
DEFERRABLE INITIALLY DEFERRED;

Level: Freelancer · More Database terms at this level

Updated September 27, 2026