DROP INDEX v16
DROP INDEX — Remove an index.
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.
The name (optionally schema-qualified) of an index to remove.
This example removes the index