Purpose
Deletes an index from a table. You can issue this statement from the MapBasic window in MapInfo Pro.
Syntax
Drop Index table( column ) table is the name of an open table.
column is the name of a column in that table.
Description
The Drop Index statement deletes an existing index from an open table. Dropping an index reduces the amount of disk space occupied by a table. (To re-create that index at a later time, issue a Create Index statement.)
The Drop Index statement takes effect immediately; no save operation is required. You cannot undo the effect of a Drop Index statement by selecting Revert Table or Undo commands. Similarly, the MapBasic Rollback statement will not undo the effect of a Drop Index statement.
Example
The following example deletes the index from the Name field of the World table.
Open Table "world"
Drop Index world(name) See Also: