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