dimanche 14 juin 2015

Android alter table UNIQUE

I have the following table,

create table test (_id integer primary key, i UNSIGNED big int, UNIQUE(i)  );

and I'm trying to remove the UNIQUE with alter like this but I'm getting an error, what is the right way to drop unique in Android Sqlite?

ALTER TABLE test DROP UNIQUE(i)

Aucun commentaire:

Enregistrer un commentaire