Approach uses ALTER TABLE to add new columnsin in sqlite. How to set the columns possition in table?

Approach uses ALTER TABLE to add columns when backup and RESTORE a database file in android. How to set new columns position in table. The columns is showing as a last columns in table but i need this column in middle.