<< Click to Display Table of Contents >> Navigation:  Local SQL > Data Definition Language > DROP INDEX

 

Deletes an index.

DROP INDEX table_reference.index_reference | PRIMARY

Description

Use the DROP INDEX statement to delete a primary or secondary index.

To delete a dBASE primary or secondary index or a Paradox secondary index, identify the index using the table name and index name separated by an identifier connector symbol (.).

DROP INDEX "Employee.dbf".Namex

To delete a Paradox primary index, identify the index with the keyword PRIMARY.

DROP INDEX Orders.PRIMARY

The existence of indexes may affect the updatability of queries. See the section on updatable queries for more information.