To change an index or key

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

1. From the main menu, click Run > Tools > Data Tools > SQL Option for DB2 > Client > 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 Alter.
8. Make the changes you require.
9. When you have finished, click OK to close the Alter Index dialog box.

   You can look at the SQL statements that will be used to make your changes by clicking SQL.

10. Click OK to close the Alter Table window.