You can modify a trigger templates properties from its property sheet. The following sections detail the property sheet tabs that contain the properties most commonly entered for trigger templates.
The General tab contains the following properties:
|
Property |
Description |
|---|---|
|
Name |
The name of the item which should be clear and meaningful, and should convey the item's purpose to non-technical users |
|
Code |
The technical name of the item used for generating code or scripts, which may be abbreviated, and should not generally include spaces |
|
Comment |
Descriptive label for the trigger template |
|
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 |
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.