Drop index for SQLCE

[albertkhor]

how to drop index?
i'm using sdf.
i use DROP INDEX 'table.idxtable' but it cannot work. Some one told me because my index table is store unit key so cannot drop, is that true?

 

[strider]

DROP INDEX tablename.indexname

The drop index wont work on indexes created as the PRIMARY KEY or UNIQUE contraints