Show TOC

Creating Triggers from ReferencesLocate this document in the navigation structure

You can create triggers to enforce referential integrity individually or instruct PowerDesigner to create them by default.

Procedure

  1. Create a reference between two tables, and then double click the reference symbol to open its property sheet.
  2. Click the Integrity tab, and then select Trigger from the Implementation list.
  3. Specify the form of Update and Delete constraints using the radio buttons (see Reference Properties), and then click OK to return to the diagram.
  4. If you have set the Automatically rebuild triggers model option (see Reference Model Options,) then triggers will have been created automatically in the parent and child tables. To verify this open the table property sheet and click the Triggers tab. If the triggers are not present, you will need to rebuild your triggers manually (see Rebuilding Triggers).
    Note To instruct PowerDesigner to implement referential integrity between tables using triggers by default whenever you create a reference, select Start of the navigation path Tools Next navigation step Model Options End of the navigation path, click Start of the navigation path Model Settings Next navigation step Reference End of the navigation path in the Category list, select Trigger in the Default implementation list.