Attributes tab, Tables tab, Materialized views tab – HP Neoview Release 2.5 Software User Manual
Page 64: Materialized view groups tab, Attributes tab tables tab
•
DDL tab
•
Privileges tab
Attributes Tab
To display the schema attributes and values that belong to the schema:
1.
Navigate to the Schema folder and click the name of the schema to see information about
the schema and its objects.
2.
Click the Attributes tab in the right pane.
In the right pane, these attributes are displayed:
•
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 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 a Schema in the navigation tree.
2.
Click 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 a Schema in the navigation tree.
2.
Click the Materialized View Groups tab in the right pane, or open the Materialized View
Groups folder.
In the right pane, these attributes are displayed:
64
Display Database Objects