Glossary: SQL Basics

Constraint

Also written: constraints, UNIQUE constraint failed, NOT NULL constraint failed

A rule the database enforces on a table, such as NOT NULL or PRIMARY KEY. Breaking one gives an error such as `UNIQUE constraint failed` (a primary key value reused) or `NOT NULL constraint failed` (a required column left empty).