HP Neoview Release 2.4 Software - Manual (Page 31)

Displaying Table Indexes and Their Properties
To display the indexes for tables, columns, and attributes:
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. Click the Tables folder and open the Indexes folder and select an index name.
In the right pane, these tabs appear:
• Columns tab
• Attributes tab
• DDL tab
• Partitions tab
Columns Tab
To display the table index columns:
1. Select a Schema in the navigation tree.
2. Click the Tables folder and open the Indexes folder and select an index name.
3. Click on the Columns tab in the right pane.
In the right pane, these attributes are displayed:
•
Column Name: Name of the column (string).
• Sort Order: Specifies the order as “Ascending” or “Descending.”
• Added By: Indicates if column was added by the “System” or “User.”
Displaying Table Indexes and Their Properties 31