CODEWITHSUNDEEP
androidsqlitecopyingdatabase-table
Waypoint
Waypoint

Reputation: 17753

Android SQLite copy table to another table

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

Upvotes: 6

Views: 10045

Answers (1)

Android Killer
Android Killer

Reputation: 18489

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.

Upvotes: 15

Related Questions