The syntax for dropping an index is as follows:

DROP INDEX table_name.index_name

table_name is the name of the dBASE file without the extension.

For FoxPro and dBASE IV or V, index_name is the tag. Otherwise, index_name is the name of the index file without the extension.

To drop the index EMPHIRE.MDX, issue the following statement:

DROP INDEX emp.emphire