HP Integrity NonStop J-Series - Manual (Page 64)

2. In the right pane, click Related Objects.
The following details appear:
•
Relationship: — This attribute specifies the relationship between this trigger and the object.
•
Related Object Type: — This attribute specifies the type of the object.
•
Related Object Name: — This attribute specifies the name of the object. The object name
is linked to the object.
•
Metadata UID: — A unique ID of the related object. This ID is a long value.
•
Creation Time: — The time and date when the related object was created. The time and
date are expressed in the yyyy-MM-dd HH:mm:ss.FFFFFF format.
•
Redefinition Time: — The time and date when the related object was last redefined. The
time and date are expressed in the yyyy-MM-dd HH:mm:ss.FFFFFF format.
•
Operation: — This attribute specifies the types of operations that are performed on this
object to activate the trigger. The value is one of the following:
◦
Delete
◦
Insert
◦
Select
◦
Update
◦
Call
•
Is Subject Table: — This attribute specifies whether the target is a subject table. The
available values are True and False.
Viewing the DDL output for a table trigger
To view the DDL output for a table trigger:
1.
In the navigation tree, select the trigger.
2. In the right pane, click DDL.
In the right pane, the DDL tab displays the DDL output for the SHOW DDL command. You can
highlight and copy contents. However, you cannot edit the contents. For more information on
the SHOW DDL command, see the HP NonStop SQL/MX Release 3.2.1 Reference Manual.
Managing objects using the SHOW DDL option
The SHOW DDL option enables you to view the DDL statements of multiple objects in a schema.
To use the SHOW DDL option for an object, right-click any object within the Schemas folder in the
navigation tree, and select SHOW DDL....
Figure 22 (page 65) shows the SHOW DDL... dialog.
64 Viewing database objects