RDBMS Fundamentals

Constraint

English

Overview

A rule set to keep data consistent.

Details

An umbrella term for data-integrity rules that can be set on a table, such as NOT NULL, uniqueness, and foreign keys. Because constraints are enforced by the database itself, they act as a last line of defense against bad data even if application-side validation has a gap.

More Database terms