Open Source RDBMS - Seamless, Scalable, Stable and Free

English | Login |Register


0
(click on this box to dismiss)

How do I drop a UNIQUE index ?

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 ?
링크 댓글 쓰기 (0)
질문시간 2년 전
ovidiuv
55
53 답변들
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 "; 

링크 댓글 쓰기 (0)
답변시간 2년 전
dba
558




You are either using a very old browser or a browser that is not supported.
In order to browse cubrid.org you need to have one of the following browsers:



Internet Explorer: Mozilla Firefox: Google Chrome: