Android: add table to database through code dynamically

Question

I want to add table to the database dynamically through code on runtime. Note: I want to add tables at any point of time.

Answer 1

You can use the below code. First, you should get the writable database and then drop the table if it is already there and create a new table.

dbs = this.getWritableDatabase();
dbs.execSQL("DROP TABLE IF EXISTS " + Table_Name);
dbs.execSQL("CREATE TABLE " + Table_Name + "(" + CID + " TEXT PRIMARY KEY, " + DName + " TEXT);");

Hope this helps!