Tutorial: Dropping an Index

To drop an index, use either the SQL Developer tool Drop or the DDL statement DROP INDEX.

This tutorial shows how to use the navigation frame and Drop tool to drop the index EVAL_JOB_IX (created in "Tutorial: Adding an Index with the Create Index Tool"). The equivalent DDL statement is:

DROP INDEX EVAL_JOB_ID;

To drop the index EVAL_JOB_IX:

1. On the Connections tab, expand hr_conn.

   Under the hr_conn icon, a list of schema object types appears.

2. Expand Indexes.

   A list of indexes appears, including EVAL_JOB_IX.

3. Right-click EVAL_JOB_IX.

   A list of choices appears.

4. Click Drop.

   The Drop window opens.

5. Click Apply.

   The Confirmation window opens.

6. Click OK.