DROP INDEX

From Lianjapedia
Revision as of 11:21, 30 January 2013 by Helen.george (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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