Deletes an index.

Syntax

DROP INDEX name

Description

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;