Trigger Naming Conventions

The pre-defined trigger templates that ship with PowerDesigner indicate naming conventions for the trigger scripts that it generates. The naming convention consists of a prefix indicating the trigger type followed by the table code.

The default naming conventions include a variable (%L:TABLE). The name of the resulting trigger script replaces this variable with a lower-case table code. For example, a resulting trigger script may have the name ti_employee.

You can change the trigger naming convention in PowerDesigner pre-defined DBMS trigger templates from the Trigger Templates tab of the DBMS property sheet.

  1. Select Database > Edit Current DBMS to open the DBMS definition file in the Resource Editor, and then click the Trigger Template tab.
  2. Click a trigger template in the list, and then click the Properties tool to open its property sheet.
  3. Type a new trigger name in the Trigger Name text box at the bottom of the tab.

    For example, mytempl_%TABLE%

  4. Click OK in each of the dialog boxes.
Parent topic: Triggers (PDM)