
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
Commentaires sur ces manuels