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

Page 26

Advertising
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

Advertising