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:
- Select one or more index names from the DB Structure view.
-
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.