DB/Assist displays the following information about indexes in the Indexes For Table dialog box:

•Name of each index defined for the table

•Whether two or more rows with duplicate key values are allowed in the table

•Corresponding column of each index

•Sort order of the index for that column. Asc indicates ascending order, and Desc indicates descending order.

To display index information for tables and views, follow these steps:

1.Open the Database Schema dialog box, as described in Examining Column Attributes.

2.In the Table/View drop-down list, select the name of a table for which an index is defined.
The Indexes push button becomes enabled.

3.Select the Indexes push button.

The Indexes For Table dialog box appears for the table you selected, as shown below.

Indexes for Table Dialog Box

4.If the name of the index you want to display does not already appear in the Index Name field, select it from the Index Name drop-down list.
The display changes to show the duplicates status, column, and sort order for the index you selected.

5.Select the Close push button or double-click on the system menu to close the dialog box.