DROP INDEX

Drop the specified index.

Syntax

DROP INDEX index-name

Description

Drops the index in the given schema (or current schema if none is provided).