beautypg.com

Attributes tab, Tables tab, Materialized views tab – HP Neoview Release 2.4 Software User Manual

Page 48: Materialized view groups tab

background image

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 aSchema 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 aSchema 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:

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).

48

Manage Database Objects