Change table schema

ODK2.0: I have a sync endpoint server. I am collecting data and syncing to the server. But over the time, if I want to add new question field to a particular form, how to sync with previous table to the server. Is it possible to throw table schema error? Could anyone please suggest.

Hi @nsthakuri,

So in general you cannot change the fields (questions) in a survey when it is on the server with data – you would have to create a “new” survey. The table is defined without the new question and cannot be changed. You could preload the existing data into the new survey, so long as the fields that do exist are reconcilable (if you only added a question).