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

Viewing tables within a schema
To view the tables within a schema:
1.
In the navigation tree, select the schema.
2. In the right pane or the Tables folder within the schema, click Tables.
The following details appear:
•
Name — The name of the table. Each table name is a hyperlink. Clicking the hyperlink
displays the details of the table.
•
Metadata UID — The internal UID number of the table.
•
Creation Time: — The time and date when the table was created. The Creation Time:
attribute is in the
yyyy-MM-dd HH:mm:ss.FFFFFF format.
•
Redefinition Time: — The time and date when the table was last redefined. The Redefinition
Time: attribute is in the
yyyy-MM-dd HH:mm:ss.FFFFFF format.
Viewing schema views
To view the schema views:
1.
In the navigation tree, select the schema.
2. In the right pane or the Views folder within the schema, click Views.
The following details appear:
•
Name — The name of the view. Each view name is a hyperlink. Clicking the hyperlink
displays the details of the view.
•
Metadata UID — The internal UID number of the view.
•
Creation Time: — The time and date when the view was created. The Creation Time:
attribute is in the
yyyy-MM-dd HH:mm:ss.FFFFFF format.
•
Redefinition Time: — The time and date when the view was last redefined. The Redefinition
Time: attribute is in the
yyyy-MM-dd HH:mm:ss.FFFFFF format.
Viewing schema procedures
To view the schema procedures:
1.
In the navigation tree, select the schema.
2. In the right pane or the Procedures folder within the schema, click Procedures.
The following details appear:
•
Name — The name of the procedure. Each procedure name is a hyperlink. Clicking the
hyperlink displays the details of the procedure.
•
Metadata UID — The internal UID number of the procedure.
•
Creation Time: — The time and date when the procedure was created. The Creation Time:
attribute is in the
yyyy-MM-dd HH:mm:ss.FFFFFF format.
•
Redefinition Time: — The time and date when the procedure was last redefined. The
Redefinition Time: attribute is in the
yyyy-MM-dd HH:mm:ss.FFFFFF format.
Viewing SQL/MP aliases within a schema
To view the SQL/MP aliases that belong to a schema:
1.
In the navigation tree, select the schema.
Viewing schemas 51