Trigger Templates (PDM)

PowerDesigner trigger templates and template items allow you to create triggers in a modular reusable fashion.

PowerDesigner uses pre-defined trigger templates to create triggers to implement referential integrity between tables. Trigger templates exist for each type of trigger supported by the DBMS. Each template specifies:


You can create trigger templates and trigger template items in your DBMS definition file or in your model. These elements will be available as follows:

Trigger template or template item created in:

Available to

DBMS (shared definition file)

All models sharing the DBMS

DBMS (copied definition file

Current model only

Model

Current model only

For more information on the DBMS share and copied definition files, see Generating a Database from a PDM.

Note:

By modifying a DBMS template item, you modify the template item definition in the current DBMS. You should only modify a DBMS that is a copy of the DBMS shipped with PowerDesigner.

For more information on working with DBMS resource files, see the DBMS Resource File Reference chapter of the Customizing and Extending PowerDesigner manual.