Referential integrity: Meaning (information, definition, explanation, facts)

Referential integrity is a concept used when dealing with relational databases. Referential integrity is usually enforced with a primary and foreign key combination. One field in a table is declared to be the foreign key. It can only contain values that are primary keys in another table, its parent table.

The RDBMS must take care that modifications to the parent table does not break the referential integrity which could happen if an item in the parent table is deleted that is referred to by a foreign key.

As an example; In a database that consists of employees and departments, it is then useful to know in which department each employee work. A foreign key "Department#" could be created in the Employee table that was only allowed to refer to a primary key in the Department table.

See also: entity integrity