Android SQLite copy table to another table

Question

I want to implement delete column in Android's SQLite. I want to make table copy without desired column, than delete former tablet and set name at new_one as a former name. I have made table to table copy, but now I have it as a 1:1 copy. How to change columns when copyiing?

Goal is to have method deleteColumn(int indexOfColumn);

Thanks

Answer 1

drop your new table first,then create a new table directly with desired columns as follows:

create table new_table as select column1,column2,....from old_table;

Here select those columns that you want to see in new table.Then drop old table and rename new table to old table's name.Hope it will work.