Attributes tab – HP Neoview Release 2.4 Software User Manual
Page 72
In the right pane, these tabs appear:
•
Attributes tab
•
Usage tab
•
DDL tab
Attributes Tab
To display the trigger attributes:
1.
Select a Schema in the navigation tree.
2.
Click the table name in the right pane, or open the Tables folder and then open the Triggers
folder and select a trigger in the tree.
3.
Click the Attributes tab in the right pane.
In the right pane, these attributes are displayed:
•
Name: Name of the trigger.
•
Is Enabled: Specifies if the trigger is enabled. The value is “'Yes” or “'No.”
•
Activation Time: Specifies when the trigger is activated. Used in combination with an
operation. The value is “Before” or “After.”
•
Operation: Specifies operation that causes the trigger to be activated. The values are
(Insert | Delete | Update).
•
Granularity: Specifies “Row” or “Statement” trigger. Row triggers are allowed for all
Time/Event combinations. Statement triggers are allowed AFTER events. For more
information, see the Neoview SQL Reference Manual.
•
Creation Time: Time and date when the trigger was created. Timestamp is in the format
(yyyy-MM-dd HH:mm:ss.FFFFFF local time).
•
Redefinition Time: Time and date when the trigger was last redefined. Timestamp is
in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
72
Manage Database Objects