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;