Deletes an index.
Syntax
DROP INDEX nameDescription
You can use the DROP INDEX command to drop an existing index from the database system. To run this command on
an index, you must be a superuser or the owner of the index. If objects depend on
the index, an error occurs, but the index is not dropped.
Parameters
| Parameter | Description |
|---|---|
| name | The name of an index to be deleted. The name can be schema-qualified. |
Examples
Delete the name_idx index:
DROP INDEX name_idx;