Glossary — in plain language

Constraint


In plain English

A constraint is a rule the database enforces on your data: NOT NULL (must have a value), UNIQUE (no duplicates), CHECK (must satisfy a condition), PRIMARY KEY, and FOREIGN KEY. If a change breaks a rule, it is rejected.

Why it matters

Constraints push data-quality rules into the database where they cannot be bypassed. Most “integrity violation” errors (class 23) are a constraint doing exactly its job.

Was this helpful?

← Browse the full glossary