Procedures tab, Synonyms tab, Ddl tab – HP Neoview Release 2.4 Software User Manual
Page 24: Privileges tab, Procedures tab synonyms tab ddl tab privileges tab
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 on 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 on 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 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”
Privileges Tab
To display the privilege information for the schema:
1.
Select a Schema in the navigation tree.
2.
Click on the Privileges tab in the right pane.
The Privileges tab displays a table showing the access privileges:
24
Managing Database Objects