Part 3: The 32-Bit Drivers : The dBASE Driver : Create and Drop Index Statements : Drop Index

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

© 2013 Progress Software Corporation and/or its subsidiaries or affiliates.