To drop an index or key on a table in the current location:
- Click
SQL for DB2
on the
Tools menu;
then click
SQL Wizard.
- If the Catalog Browser window is not open, click

to open it.
- On the Catalog Browser window, ensure the
Table tab is selected.
- Click the table you want.
- Click
Alter.
- In the
Indexes and Keys group, select the index or key you want to change from the list.
- Click
Drop.
- Click
OK to close the Create Index dialog box.
- Click
OK to close the Alter Table window.