Modifying a Trigger Template Item

You can modify both your template items and those that are provided with PowerDesigner.

  1. Open the trigger template item property sheet in one of the following ways:
    • To modify a DBMS trigger template item: select Database > Edit Current DBMS to open the DBMS definition file in the resource editor, and then click the Trigger Template Items tab.
    • To modify a model trigger template item: select Model > Triggers > Trigger Templates Items to open the List of User-Defined Trigger Template Items.
  2. Click a trigger template item in the list, and then click the Properties tool to open its property sheet.
  3. Click the Definition tab and modify the trigger definition code. You can use PDM variables and macros and various other tools available from the toolbar (see SQL Editor Tools).
  4. You can also modify other of the trigger template item's properties. For a full list of the properties available, see Trigger Template Item Properties.
  5. Click OK in each of the dialog boxes.

    If you have created DBMS trigger template item, a confirmation box will appear, asking if you want to save the changes to the DBMS.

    Click Yes to confirm the template creation.