General Rules for Creating Referential Integrity Constraints

You should follow certain guidelines when creating referential integrity constraints.

When you define referential integrity constraints in a table:

Referential integrity constraints provide a simpler way to enforce data integrity than triggers. However, triggers provide additional capabilities to enforce referential integrity between tables.

Related concepts
Triggers: Enforce Referential Integrity