beautypg.com

Display views and their properties, Columns tab – HP Neoview Release 2.5 Software User Manual

Page 74

background image

The detailed summary is a snapshot of the indexes (tables indexes and materialized view indexes)
in the schema at the timestamp shown at the top of the table display. If you select [ Refresh ] the
summary is refreshed. A row is highlighted in red if the partition is equal to or greater than 80%.

Display Views and Their Properties

To display the view information:

1.

Start the HP Database Manager and log on using any user ID.

2.

Click the Database area.

3.

Select a system in My Systems in the navigation tree.

4.

Select a Schema in the navigation tree.

5.

In the navigation tree pane, expand the Views folder, and select a view.

In the right pane, these tabs appear:

Columns tab

Usage tab

DDL tab

Privileges tab

Columns Tab

To display the column information for a view:

74

Display Database Objects