Deleting an Index 
Use
You can use SQL Studio to delete the index of a database table.
Prerequisites
You have the required user authorizations.*
Procedure
1. In the Catalog Manager, select the index that you want to delete.
2. Choose Catalog Manager ® Drop Index.
*For an explanation
of user authorizations, see the
User Concept
section of the documentation The SAP DB Database System.