You are here: Reference Information > SQL Reference Information > SQL Statements > DROP INDEX

DROP INDEX

DROP INDEX — remove an index

Syntax

DROP INDEX [schema.]index_name [IF EXISTS]

Description

DROP INDEX drops an existing index from the database system. To execute this command you must be the owner of the index. If the index does not exist and you specify IF EXISTS, NuoDB does not generate an error. Otherwise an error is generated if the index does not exist. Refer to CREATE INDEX for information on how to create indexes.

A UNIQUE INDEX that is referenced by a FOREIGN KEY constraint cannot be dropped. The FOREIGN KEY constraint on the referencing table must first be dropped. See ALTER TABLE for details on how to drop a FOREIGN KEY constraint.

Parameters

Examples