Difference between revisions of "DROP INDEX"
From Lianjapedia
Yvonne.milne (Talk | contribs) m (1 revision: SQL) |
Helen.george (Talk | contribs) |
||
(3 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
==Purpose== | ==Purpose== | ||
Removes an index from a table | Removes an index from a table | ||
− | |||
==Syntax== | ==Syntax== | ||
DROP INDEX <index> ON <table> | DROP INDEX <index> ON <table> | ||
− | |||
==See Also== | ==See Also== | ||
[[ADD TABLE]], [[ALTER INDEX]], [[ALTER TABLE]], [[CREATE INDEX]], [[CREATE TABLE]], [[OPEN DATABASE]] | [[ADD TABLE]], [[ALTER INDEX]], [[ALTER TABLE]], [[CREATE INDEX]], [[CREATE TABLE]], [[OPEN DATABASE]] | ||
− | |||
==Description== | ==Description== | ||
Line 16: | Line 13: | ||
The table must be able to be locked for EXCLUSIVE use during the operation. | The table must be able to be locked for EXCLUSIVE use during the operation. | ||
− | + | {| class="wikitable" width="100%" | |
− | + | ||
− | {| class="wikitable" | + | |
!Keywords||Description | !Keywords||Description | ||
|- | |- | ||
Line 26: | Line 21: | ||
|- | |- | ||
|} | |} | ||
− | |||
==Example== | ==Example== | ||
Line 32: | Line 26: | ||
DROP INDEX staff_no ON staff | DROP INDEX staff_no ON staff | ||
</code> | </code> | ||
− | |||
==Products== | ==Products== | ||
− | + | Lianja Server, Lianja | |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
[[Category:Commands]] | [[Category:Commands]] |
Latest revision as of 11:21, 30 January 2013
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