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.

The General tab contains the following properties:

Property

Description

Name/Code/Comment

Identify the object. The name should clearly convey the object's purpose to non-technical users, while the code, which is used for generating code or scripts, may be abbreviated, and should not normally include spaces. You can optionally add a comment to provide more detailed information about the object. By default the code is generated from the name by applying the naming conventions specified in the model options. To decouple name-code synchronization, click to release the = button to the right of the Code field.

DBMS

Current DBMS

Trigger time

Time attribute of the trigger template. The list displays the values defined in the trigger templates and template items of the current DBMS

Trigger event

Event attribute of the trigger template. The list displays the values defined in the trigger templates and template items of the current DBMS

Trigger name

Name of trigger associated with template

Applies to table triggers or view triggers

For those DBMS that support view triggers, it allows you to define if the trigger template applies to table or view triggers

Keywords

Provide a way of loosely grouping objects through tagging. To enter multiple keywords, separate them with commas.

Definition Tab

This tab contains a field for entering its definition code (see Modifying Triggers).

Template Items Tab

This tab list the template items that are defined in the trigger template and that will be generated when a trigger is generated from the template.

You can add any template item from the model or DBMS to the Trigger template definition by clicking an Add Trigger Item tool on the Definition tab, and selecting a trigger item. It is automatically added to this tab.

A template item that is deleted from this tab is not deleted from the trigger template definition. You can therefore limit the template items available for generation by removing template items from this tab, without having to remove them from the trigger template definition.

When you use Rebuild Triggers to automatically create triggers for selected tables, the template items that are listed on this tab are those available for generation. Whether they are generated or not depends on the following:
  • Template items are generated in a trigger if they match the trigger implemented referential integrity defined for a reference attached to the table

  • Template items are generated in a trigger if they are user-defined, regardless of trigger referential integrity constraints