HP Neoview Release 2.4 Software - Manual (Page 50)

Usage Tab
To display the synonym usage information:
1. Select a Schema in the navigation tree.
2. Click on the Synonyms tab in the right pane and select a synonym name, or open the
Synonyms folder and select a synonym name in the tree.
3. Click on the Usage tab in the right pane.
The Usage tab displays the usage relationships of the synonym with other objects, if any.
These attributes displayed are:
•
Relationship: Specifies the relationship of the synonym with the object specified. The
value is “References.”
• Related Object Type: Specifies the object type of the object that the synonym references.
The values are: “Table,” “Materialized View,” or “View.”
• Related Object Name: Specifies the 2-part ANSI object name with a hyperlink to the
object.
• Creation Time: Time and date when the synonym was created. Timestamp is in the
format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
• Redefinition Time: Time and date when the synonym was last redefined. Timestamp
is in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
DDL Tab
To display the DDL output for the synonym:
1. Select a Schema in the navigation tree.
2. Click on the Synonyms tab in the right pane and select a synonym name, or open the
Synonyms folder and select a synonym name in the tree.
3. Click on the DDL tab in the right pane.
The DDL tab displays DDL output from the SHOWDDL command in the right pane. You
can highlight and copy contents, but you cannot edit the contents. For more information
about the format of the SHOWDDL command, see the SQL Reference Manual.
For more information about displaying DDL, see “Displaying Schema DDL and Their Properties”
(page 53) .
50 Managing Database Objects