Previous PageTable Of ContentsNext Page

3.3.32 DROP INDEX

Name

DROP INDEX -- remove an index

Synopsis

DROP INDEX name

Description

DROP INDEX drops an existing index from the database system. To execute this command you must be a superuser or the owner of the index. If any objects depend on the index, an error will be given and the index will not be dropped.

Parameters

name

The name (optionally schema-qualified) of an index to remove.

Examples

This command will remove the index, name_idx:

DROP INDEX name_idx;

See Also

ALTER INDEX, CREATE INDEX

Previous PageTable Of ContentsNext Page