A constraint that guarantees the data a foreign key points to always exists.
A constraint that guarantees the primary-key value a foreign key references always exists, preventing orphaned records. Because of this constraint, trying to delete a parent-table row that's still referenced causes the database to reject the delete with an error as long as related child-table rows remain (unless a cascade rule is set).
© 2026 ITBGM