I created a unique index in SQLCE using "CREATE UNIQUE INDEX "idxABC" ON "ABC"". Now I want to drop this index, may I know how do I do that?
I tried "DROP INDEX "ABC.idxABC"", doesn't work. The document says it won't work on PRIMARY KEY or UNIQUE INDEX anyway.
I tried "ALTER TABLE "ABC" DROP CONSTRAINT "idxABC"", doesn't work too.
What should I do? Thanks in advance!