Tables tab, Materialized views tab, Materialized view groups tab – HP Neoview Release 2.4 Software User Manual
Page 23: Views tab
Name: Name of the schema.
•
•
Owner: The owner of the schema.
•
Version: Specfies the version of the schema.
Tables Tab
To display the table names that belong to the schema:
1.
Select a Schema in the navigation tree.
2.
Click on the Tables tab in the right pane, or open the Tables folder.
In the right pane, these attributes are displayed:
•
Name: Name of the table. Each table name is hyperlinked and detailed information
about the table is displayed.
•
Creation Time: Time and date when the table was created. Timestamp is in the format
(yyyy-MM-dd HH:mm:ss.FFFFFF local time).
•
Redefinition Time: Time and date when the table was last redefined. Timestamp is in
the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
Materialized Views Tab
To display the materialized views that belong to the schema:
1.
Select aSchema in the navigation tree.
2.
Click on the Materialized Views tab in the right pane, or open the Materialized Views
folder.
In the right pane, these attributes are displayed:
•
Name: Name of the materialized view. Each materialized view is hyperlinked and
detailed information about the materialized view is displayed.
•
Creation Time: Time and date when the materialized view was created. Timestamp is
in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
•
Redefinition Time: Time and date when the materialized view was last redefined.
Timestamp is in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
Materialized View Groups Tab
To display the materialized view groups that belong to the schema:
1.
Select aSchema in the navigation tree.
2.
Click on the Materialized View Groups tab in the right pane, or open the Materialized
View Groups folder.
In the right pane, these attributes are displayed:
•
Name: Name of the materialized view groups. Each materialized view group is
hyperlinked and detailed information about the materialized view group is displayed.
•
Creation Time: Time and date when the materialized view groups was created.
Timestamp is in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
•
Redefinition Time: Time and date when the materialized view groups was last
redefined. Timestamp is in the format (yyyy-MM-dd HH:mm:ss.FFFFFF local time).
Views Tab
To display the views that belong to the schema:
1.
Select aSchema in the navigation tree.
2.
Click on the Views tab in the right pane, or open the Views folder.
In the right pane, these attributes are displayed:
Displaying Schemas and Their Objects
23