User guide

Managing Indexes14-8
Dropping an Index
Use the Drop Index window to delete an index. Before dropping an index,
you can analyze the impact of dropping it by displaying a list of SQL
objects that depend on the index.
To display the Drop Index window, click on Indexes in the Main window,
then click on Drop. The Drop Index window is displayed, as shown in
Figure 14-3.
Figure 14-3. Drop Index Window.
Choose an Index
Use the Catalogs and Index pane to choose the index for deletion. To
choose an index to drop
1. In the Catalogs field, double-click on the name of the catalog that
contains the index. The indexes in the catalog are displayed in the
Indexes field.
2. In the Indexes field, double-click on the name of the index you want to
drop. The attributes of the index are displayed.