DROP INDEX v11
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