Removes an index from a table
DROP INDEX <index> ON <table>
The DROP INDEX command removes an index from a table. When the index is dropped it frees the disk space which it occupied.
The table must be able to be locked for EXCLUSIVE use during the operation.
|index||The name of the index to be dropped.|
|table||The name of the table from which to drop the index.|
DROP INDEX staff_no ON staff
Lianja Server, Lianja