Chapter 6 Building Triggers and Procedures

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:

a Time – relevant to an event. One of:
- After
- Before
an Event – that can occur to a table row. One of:
- Delete
- Insert
- Update
Code – that performs the trigger action. The code may contain references to trigger template items, which are re-usable blocks of script.

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 the "Generating a Database from a PDM" chapter.

Modifying DBMS template items
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 creating and copying a DBMS, see the "The Resource Editor" chapter in the General Features Guide .