Difference between revisions of "DROP INDEX"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (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 | ||
| Line 15: | Line 8: | ||
==See Also== | ==See Also== | ||
| − | [[ADD TABLE]], [[ALTER INDEX]], [[CREATE INDEX]], [[ | + | [[ADD TABLE]], [[ALTER INDEX]], [[ALTER TABLE]], [[CREATE INDEX]], [[CREATE TABLE]], [[OPEN DATABASE]] |
| Line 37: | Line 30: | ||
==Example== | ==Example== | ||
<code lang="recital"> | <code lang="recital"> | ||
| − | DROP INDEX staff_no ON staff | + | DROP INDEX staff_no ON staff |
</code> | </code> | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:SQL]] | [[Category:SQL]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
Latest revision as of 17:35, 22 December 2009
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
Recital Server, Recital
