Physical Modeling › Triggers › Change the Default Referential Integrity Settings for All Relationships

Change the Default Referential Integrity Settings for All Relationships

You can use the Model Properties dialog to change the default referential integrity settings for all relationships.

To change the default referential integrity settings for all relationships

1. Click Model Properties on the Model menu.

   The Model Properties dialog opens.

2. Select the RI Defaults tab and select any of the following options:
   • To change a referential integrity action for any SQL action and relationship type, select a new action from the available lists.
   • To return the settings to the system default, click Reset.
   • To apply the new default settings to any relationship in a model, click Rebind.
3. Click OK.