Difference between revisions of "DROP INDEX"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision: SQL) |
m (Text replace - "Recital" to "Lianja") |
||
| Line 35: | Line 35: | ||
==Products== | ==Products== | ||
| − | + | Lianja Server, Lianja | |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
Revision as of 12:47, 7 December 2012
Purpose
Removes an index from a table
Syntax
DROP INDEX <index> ON <table>
See Also
ADD TABLE, ALTER INDEX, ALTER TABLE, CREATE INDEX, CREATE TABLE, OPEN DATABASE
Description
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.
| Keywords | Description |
|---|---|
| index | The name of the index to be dropped. |
| table | The name of the table from which to drop the index. |
Example
DROP INDEX staff_no ON staff
Products
Lianja Server, Lianja
