Dropping an Index 

Prerequisites

You need to have the required user authorizations.

For an explanation of user authorizations, see the Database users section of the Concepts of the Database System documentation.

Procedure

...

       1.      In Catalog Manager, select the index that you want to delete.

       2.      Choose Catalog Manager ® Drop Object