To
drop an Index:
Click the Index object in the tree. The indexes in the database are listed.
Select the index to be dropped and click the Drop button. The Drop Index dialog box is displayed.

Click OK. All the remaining indexes in the database will be displayed on the Properties page.
Related topic: