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

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