What is a CHECK constraint?

Question

Accepted Answer

## CHECK Constraints A `CHECK` constraint enforces domain integrity by validating values before they are written to a column. If a query tries to write a value that evaluates to `FALSE`, the database rejects the statement and raises a constraint violation error: ### Common Formats - **Range checks:** `CHECK (age >= 18)` - **Format pattern checks:** `CHECK (email LIKE '%@%')` - **In-list options checks:** `CHECK (status IN ('active', 'inactive'))` - **Multi-column check constraints:** `CHECK (sale_price < original_price)`

What is a CHECK constraint?

Understand the problem

Attempt it yourself

Stuck? AI Nudge Available

Study the solution

The solution is waiting

Run the code

Join the discussion

Discussion (0)