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, and you can also create your own. Trigger templates exist for each type of trigger supported by the DBMS, each identifying:

A time relevant to an event (either before or after)
An event that can occur to a table row (either Delete, Insert, or Update)
The code that performs the trigger action, and which 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 (see Viewing and Editing the DBMS Definition File) or in your model.

Creating a Trigger Template
You can create a new trigger template in your DBMS definition file or as part of your model. You can begin by copying an existing template or write one from scratch.
PowerDesigner Pre-defined Trigger Templates
The pre-defined DBMS templates provided with PowerDesigner control referential integrity constraints for insert, update, and delete events. Depending on the current DBMS, there is a before and after event template for each trigger type.
Modifying a Trigger Template
You can modify both your templates and those that are provided with PowerDesigner.
Trigger Template Properties
To view or edit a trigger template's properties, double-click its Browser or list entry. The property sheet tabs and fields listed here are those available by default, before any customization of the interface by you or an administrator.

Parent topic: Triggers and Procedures