When I create places table in mashup.db, I created country_code as primary key and not be null until I realize how stupid this is. But how could I change it using sqlite statement? Or should I just create another table? Besides, what's the data type for column accuracy? Numeric or Integer? Or does it matter?


1 Answer 1


SQLite does not support the alter table drop constraint commands. You will need to create a new table without the primary key.

The column accuracy is an Integer.


You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .