Try OpenEdge Now
skip to main content
Online Help
Introducing Progress DB Navigator : Tasks : Working with OpenEdge databases : Viewing and maintaining OpenEdge database schema : Working with OpenEdge database indexes : Displaying OpenEdge database index details
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.