referential integrity

The guarantee that every foreign key value points at a row that really exists.

In more detail

Without it, deleting a customer can leave orders pointing at nobody, a dangling reference. Foreign key constraints enforce it inside the database, for every program that writes, which an application-level check cannot do.

Related terms

Taught in

References