Displaying OpenEdge database index details

To display index details, select a table name (or one of the table's child nodes) in the DB Structure view.

Index information appears in the DB Details view under the Indexes tab and the OpenEdge Indexes tab.

The Indexes tab displays a list of all indexes in the table that conform to SQL standards. Details in the list include the type of index; whether the index is unique; and which fields comprise the index, their ASCII order, and whether they are ascending or descending.

The OpenEdge Indexes tab displays OpenEdge-specific attributes such as primary, active, unique, word index, field type, and sort order.