Physical Modeling › Triggers › Referential Integrity Triggers (RI Triggers)

Referential Integrity Triggers (RI Triggers)

You can implement referential integrity triggers (RI triggers), which are triggers that maintain the integrity between two related tables. For example, if a row in a parent table is inserted, updated, or deleted, an RI trigger tells the DBMS what to do to rows in other tables that have a foreign key value that matches the primary key in the row being added, updated, or deleted.

A set of default RI trigger templates is provided that you can attach to tables to tell the target server how to enforce referential integrity. Default RI options are associated to each action in a relationship based upon the following criteria:

• Table role (Parent/Child)
• Action
• Relationship type