referential integrity (RI)

Referential integrity is a mechanism that ensures that all foreign keys have an associated primary key in related tables. Referential integrity constraints prevent having foreign keys pointing to non-existent primary keys and enforces the relationship between tables. See also primary key, foreign key.