DROP INDEX v14

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

CREATE INDEX, ALTER INDEX