beautypg.com

Displaying views and their properties, Columns tab – HP Neoview Release 2.4 Software User Manual

Page 34

background image

Displaying 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 Active Systems in the navigation tree.

4.

Select a Schema in the navigation tree.

5.

Select the Views tab in the right pane, or open the Views folder and select a view. HPDM
displays the views in this schema.

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:

1.

Select a Schema in the navigation tree.

2.

Click the Views tab, or open the Views folder and select a view.

3.

Click on the Columns tab in the right pane. The column information is displayed in each
column.

In the right pane, these usages are displayed:

Column Name: Name of the column (string).

Source Object: The name of the source object. If it is a computed object, this is blank.
The name is hyperlinked to show that clicking on the source object name navigates you
to the location of the object.

34

Managing Database Objects