To view or edit a trigger'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. |
Stereotype |
Extends the semantics of the object. You can enter a stereotype directly in this field, or add stereotypes to the list by specifying them in an extension file. |
|
Owner |
Specifies the name of the trigger owner, chosen from the list of users. A trigger can only have one owner, and this is normally the trigger creator. |
|
Table |
[Table or view triggers only] Specifies the table to which the trigger belongs. |
|
Scope |
[DBMS triggers only] Specifies the scope of the DBMS trigger. You can choose either Schema or Database, and this choice will control the types of events that you can select in the DBMS trigger definition. |
|
Generate |
Specifies to generate the trigger. |
|
User-defined |
[Read-only] Specifies that the trigger definition has been modified. You modify a trigger definition when you change the trigger template script in the Definition tab of the trigger |
Keywords |
Provide a way of loosely grouping objects through tagging. To enter multiple keywords, separate them with commas. |
This tab allows you to enter code for the trigger. For information about the tools available on the toolbar, see SQL Editor Tools. The following properties are available:
|
Property |
Description |
|---|---|
|
Template |
Specifies the template on which the trigger is based (see Trigger Templates (PDM)). The User-defined button is automatically depressed when you modify the definition of a trigger. Click the button to release it and restore the template trigger definition. |
|
Time |
Specifies when the trigger will fire in relation to the associated event. The content of the list depends on the values defined in the trigger template and in the Time entry in the Trigger category of the DBMS. |
|
Event |
Specifies the event that will cause the trigger to fire. Click the ellipsis tool to the right of this field to select multiple events (see Defining Triggers with Multiple Events) For table and view triggers, this field is a list, the content of which depends on the values defined in the trigger template and in the Event entry in the Trigger category of the DBMS. You can add your own events to this entry and they will appear in this list. For DBMS triggers, this field allows you to enter any text. |
|
Order |
[table and view triggers only] Specifies the firing order of trigger. |