Creating Triggers

You can create triggers for referential integrity individually or by default, and create your own triggers from the property sheet of a table (or view, if supported by your DBMS).

You can write a trigger from scratch directly in its property sheet, but we recommend that you use a trigger template and/or trigger template items to define the trigger code. These allow you to create triggers in a modular fashion, to make re-use of your trigger code easier and give your triggers more portability (see Trigger Templates (PDM)).

• Implementing Referential Integrity with Triggers
  You can create triggers for referential integrity individually or instruct PowerDesigner to create them by default.
• Creating a Trigger from a Template
  You can create a trigger based on one of the PowerDesigner templates or on a template of your own.
• Creating a Trigger from Scratch
  You can create a trigger without basing it on a template. However, we recommend that you use a template as this will simplify reuse of your code and make your triggers more portable.