Introduction

---

The SQL DROP INDEX statement is used to delete a primary or secondary index from a table.

Syntax

---

DROP INDEX [IF EXISTS]
table_reference.index_name | PRIMARY

Use the DROP INDEX statement to delete a primary or secondary index. To delete a secondary index, identify the index using the table name and index name separated by an identifier connector symbol (.):

DROP INDEX Employee."Last Name"

To delete a primary index, identify the index with the keyword PRIMARY:

DROP INDEX Orders.PRIMARY

Please see the Adding and Deleting Indexes from a Table topic for more information on deleting indexes.