HP Integrity NonStop J-Series - Manual (Page 60)

6. Expand the contents of a table.
The Indexes and Triggers folders appear.
7. Within the Indexes folder, select the required Index.
In the right pane, the following tabs related to the Index appear:
•
Columns
•
Attributes
•
DDL
•
Partitions
Figure 20 (page 60) shows the table index properties.
Figure 20 Table index properties
Viewing the table index columns
To view the table index columns:
1.
In the navigation tree, select the index.
2. In the right pane, click Columns.
The following attributes and their values appear:
•
Column Name: — The name of the column (string).
•
Sort Order: — This attribute specifies the sort order as Ascending or Descending.
•
Added By: — This attribute ndicates whether the column was added by the system or a
user.
Viewing the table index attributes
To view the table index attributes:
1.
In the navigation tree, select the index.
60 Viewing database objects