Difference between revisions of "DROP INDEX"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
==Class== | ==Class== | ||
SQL Applications | SQL Applications | ||
Revision as of 10:15, 29 April 2009
Class
SQL Applications
Purpose
Removes an index from a table
Syntax
DROP INDEX <index> ON <table>
See Also
ADD TABLE, ALTER INDEX, CREATE INDEX, SET TCACHE
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 Database Server, Recital Mirage Server, Recital Terminal Developer
