Difference between revisions of "DROP INDEX"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 8: Line 8:
  
 
==See Also==
 
==See Also==
[[ADD TABLE]], [[ALTER INDEX]], [[CREATE INDEX]], [[SET TCACHE]]
+
[[ADD TABLE]], [[ALTER INDEX]], [[ALTER TABLE]], [[CREATE INDEX]], [[CREATE TABLE]], [[OPEN DATABASE]]
  
  
Line 30: Line 30:
 
==Example==
 
==Example==
 
<code lang="recital">
 
<code lang="recital">
DROP INDEX staff_no ON staff;
+
DROP INDEX staff_no ON staff
 
</code>
 
</code>
  

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