Previous Topic: Assign a Rolename to a Migrated IndexNext Topic: Assign Relationship UDP Values in a Physical Model

Relationships and Domains › Relationships in the Physical Model › Define Referential Integrity Trigger Actions for Relationships

Define Referential Integrity Trigger Actions for Relationships

Business rules express how a business uses its data. You can set built-in referential integrity actions to capture common business rules that apply to the relationships between data in different tables. You can enforce these rules using referential integrity trigger actions. These actions tell the database management system what action to take when you attempt to delete, insert, or update a row in a table. Use the RI Actions tab in the Relationships editor to define referential integrity trigger actions for relationships.

To define referential integrity trigger actions for relationships

  1. Click Relationships on the Model menu.

    The Relationship editor opens.

  2. Select a relationship from the Relationship drop-down list for which you want to define referential integrity trigger actions, then click the RI Actions tab.

    The RI Actions tab opens.

  3. Select your choices for the following RI Actions:
    Child Delete

    Specifies the referential integrity trigger action that you want to occur when data in the child table is deleted.

    Child Insert

    Specifies the referential integrity trigger action that you want to occur when data in the child table is inserted.

    Child Update

    Specifies the referential integrity trigger action that you want to occur when data in the child table is updated.

    Parent Delete

    Specifies the referential integrity trigger action that you want to occur when data in the parent table is deleted.

    Parent Insert

    Specifies the referential integrity trigger action that you want to occur when data in the parent table is inserted.

    Parent Update

    Specifies the referential integrity trigger action that you want to occur when data in the parent table is updated.

  4. Click OK.

    The referential integrity trigger actions for the relationship are defined and the Relationships editor closes.