Difference between revisions of "DROP INDEX"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 1: Line 1:
=DROP INDEX=
 
 
 
 
==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