Drop Index
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
