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 : Dropping OpenEdge database indexes
 
Dropping OpenEdge database indexes
While you can drop an OpenEdge database index, you cannot delete the primary index. To drop the index that is currently the primary index, you must first make another index the primary index.
To delete an index from a table:
1. Select one or more index names from the DB Structure view.
2. Right-click, and choose Drop Index from the context menu. A confirmation dialog prompts you to confirm the deletion. (Drop Index is also available on the OpenEdge Columns tab of the DB Details view.)
Note: To delete multiple indexes simultaneously, select multiple indexes in the DB Structure view, and then right-click and select Drop Index from the context menu.