
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
Comentarios a estos manuales