IT lexicon › Database › Referential integrity

Referential integrity

Database På svenska → Updated: 2026-05-23

The guarantee that foreign keys always point to a row that exists — no "orphans".

The database refuses INSERT if the FK points to nothing. DELETE of a parent row: CASCADE (delete the children), RESTRICT (refuse), SET NULL. Modern microservice architectures often forgo this for flexibility — a tricky trade.

← Back to the lexicon