Views tab, Procedures tab, Synonyms tab – HP Neoview Release 2.4 Software User Manual
Page 49: Ddl tab, Views tab procedures tab synonyms tab ddl tab
Views Tab
To display the views that belong to the schema:
1.
Select aSchema in the navigation tree.
2.
Click the Views tab in the right pane, or open the Views folder.
In the right pane, these attributes are displayed:
•
Name: Name of the view. Each view is hyperlinked and detailed information about the
view is displayed.
•
Creation Time: Time and date when the view was created. Timestamp is in the format
(yyyy-MM-dd HH:mm:ss.FFFFFF local time).
•
Redefinition Time: Time and date when the view was last redefined. Timestamp is in
the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
Procedures Tab
To display the procedures that belong to the schema:
1.
Select a Schema in the navigation tree.
2.
Click the Procedures tab in the right pane, or open the Procedures folder.
In the right pane, these attributes are displayed:
•
Name: Name of the procedure. Each procedure name is hyperlinked and detailed
information about the procedure is displayed.
•
Creation Time: Time and date when the procedure was created. Timestamp is in the
format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
•
Redefinition Time: Time and date when the procedure was last redefined. Timestamp
is in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
Synonyms Tab
To display the synonyms that belong to the schema:
1.
Select a Schema in the navigation tree.
2.
Click the Synonyms tab in the right pane, or open the Synonyms folder.
In the right pane, these attributes are displayed:
•
Name: Name of the synonym. Each synonym name is hyperlinked and detailed
information about the synonym is displayed.
•
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 schema:
1.
Select a Schema in the navigation tree.
2.
Click 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 Neoview SQL
Reference Manual.
For more information about displaying DDL, see
“Display Schema DDL and Their Properties”
Display Schemas and Their Objects
49