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. |
This tab contains a field for entering its definition code (see Modifying Triggers).
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.