how to add column in the existing table LOGIN. here’s my sample code. this is my DataBaseAdapter class: this is my LoginDataBaseAdapter how can I add the columns FIRSTNAME(from TextView), LASTNAME(from TextView), DEPARTMENT(from Spinner). Answer You’ll have to update your SQLite database version first of all, then that will run your onUpgrade() method, which will drop all of your data.