beautypg.com

Displaying tables and their properties – HP Neoview Release 2.4 Software User Manual

Page 26

background image

Displaying Tables and Their Properties

To display the table columns, primary key information, attributes, and usage 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 and click the table name in the right pane, or open the Tables folder. HPDM
displays the tables in the schema.

In the right pane, these tabs appear:

Columns tab

Primary Key tab

Hash Key tab

Unique Constraints tab

Foreign Keys tab

Attributes tab

Partitions tab

Usage tab

DDL tab

Statistics tab

Privileges tab

You can also expand Tables to display a table list in the left pane. Each table in the navigation
tree contains a folder called Indexes and a folder called Triggers. The Indexes folder expands
to show the indexes of a specified table. The Triggers folder expands to show the triggers
of a specified table.

26

Managing Database Objects