How do I drop a UNIQUE index ?

Question

0

(click on this box to dismiss)

I ran the following commands:

CREATE TABLE "ITEMS" ("N" integer, "A" integer);

CREATE UNIQUE INDEX "test_index" ON "ITEMS" ("N");

ALTER TABLE "ITEMS" DROP INDEX " test_index";

and I got the error:

Error description:

Index "test_index" does not exist.

How can I remove this unique index ?

link comment (0)

asked 7 months ago

55

Answer 1

0

If the index is unique or reverse it must be specified within the drop index clause. So, the correct query is:

ALTER TABLE "ITEMS" DROP UNIQUE INDEX " test_index ";

link comment (0)

answered 7 months ago

558

Related Questions