Chapter 5 Building Triggers and Procedures

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 page of the DBMS property sheet.

Steps To change trigger naming conventions in a DBMS trigger template:

  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 page.

    For example, mytempl_%TABLE%
  4. Click OK in each of the dialog boxes.

 

Copyright (C) 2005. Sybase Inc. All rights reserved.