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?



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 .