79792

Deleting an lndex

If you no longcr nccd an index, thcn you can dclcte it using SQL Devcloper.

In this example. you dclete thc PROD_DESC_I DX indcx that you created previously on

the SH.PRODUCTS table in "Example: Creating an Indcx" on page 8-22.

To delete the description index on the SH.PRODUCTS tahle:

1.    View the tables in the SH schema, by following the instructions in "Viewing Tables"

on page 8-10.

See Also:

■"About Indexes" on page 8-20

Notę: You cannot delete an index that is currently used to cnforcc a constraint. You must disable or delete thc constraint and then, if the index is not deletcd as a result of that action, delete the index.

Managing Views

8-24 Oracle Database 2 Day DBA

2.    Right-click thc PRODUCTS table, and selcct Index. and then Drop.

The Drop dialog box appears, with the Prompts tab displayed.

3.    In the Drop Index field, select PROD_DESC_IDX.

4.    Click Apply.

A confirmation message appears.