DROP INDEX v16

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 occurs, and the index isn't dropped.

Parameters

name

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

Examples

This example removes the index name_idx:

DROP INDEX name_idx;

See also

CREATE INDEX, ALTER INDEX