# Initially Immediate

A constraint mode starting each transaction with checking performed after each statement.

## What is **Initially Immediate** in a relational database?

**Initially Immediate** — A constraint mode starting each transaction with checking performed after each statement.

```sql
ALTER TABLE enrollment
ADD CONSTRAINT enrollment_course_fk
FOREIGN KEY (course_id) REFERENCES course (course_id)
DEFERRABLE INITIALLY IMMEDIATE;
```

Level: Freelancer · [More Database terms at this level](https://www.ask-codey.com/glossary/subjects/database/freelancer)

Updated: September 27, 2026

Source: https://www.ask-codey.com/glossary/initially-immediate