You can modify an object's properties from its property sheet. To open a trigger property sheet, double-click its Browser entry in the Triggers or DBMS Triggers folder. The following sections detail the property sheet tabs that contain the properties most commonly entered for triggers.
|
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 |
|
Stereotype |
Sub-classification used to extend the semantics of an object without changing its structure; it can be predefined or user-defined |
|
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 |