Chapter 5 Building Triggers and Procedures

Modifying Triggers

PowerDesigner provides various methods for editing a trigger. You can:

Edit the code directly in the Definition tab of its property sheet.
Attach a predefined trigger template or create and attach your own reusable trigger templates
Insert predefined trigger template item code or create your own reusable trigger template items

Always work on a copy of your DBMS definition file
If you modify the definition of a DBMS trigger template or template item, you are modifying the DBMS definition file. We recommend that you only ever work on a copy of the original DBMS definition file.

To modify a trigger:

Open the trigger property sheet in one of the following ways:
- Open the relevant table property sheet click the Triggers tab, select the trigger from the list, and then click the Properties tool
- Select Model→Triggers→Triggers to open the List of Triggers, select the trigger from the list, and then click the Properties tool
- In the Browser, find the entry for the trigger, right-click it, and select Properties from the contextual menu

Click the Definition tab to display the trigger code.

Enter the trigger definition code. You can attach a trigger template, add template items, use PDM variables and macros and various other tools available from the toolbar (see "Using the Definition tab toolbar").

The trigger will be marked as user-defined and will be excluded from most forms of rebuilding (see "Rebuilding Triggers"), if you select the "Preserve" mode.

You can also modify the trigger's other properties. For a full list of the properties available, see "Trigger properties".

Click OK in each of the dialog boxes.