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


DROP INDEX — remove an index


DROP INDEX [schema.]index_name [IF EXISTS]


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.