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

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.
52 Viewing database objects