To drop an index or key

To drop an index or key on a table in the current location:

1. Click SQL for DB2 on the Tools menu; then click SQL Wizard.
2. If the Catalog Browser window is not open, click
   
   to open it.
3. On the Catalog Browser window, ensure the Table tab is selected.
4. Click the table you want.
5. Click Alter.
6. In the Indexes and Keys group, select the index or key you want to change from the list.
7. Click Drop.
8. Click OK to close the Create Index dialog box.
9. Click OK to close the Alter Table window.