Android Database add column

Question

is there any simple way how to add column or update column via SQlite in Android?

Now I am using raw SQL:

public void addColumn(String tableName, String ColumnName, String ColumnType, String AdditionalDetails){
    SQLiteDatabase db=dtbhelper.getWritableDatabase();
    db.execSQL("ALTER TABLE "+tableName+" ADD COLUMN "+ColumnName+" "+ColumnType+" "+AdditionalDetails+";");
    Log.d("TAG","FINISHED");
}

THanks

slkorolev · Accepted Answer · 2011-11-03 08:44:03Z

1

Your query looks correct. In SQLite you only can ADD column and you cannot UPDATE it. Also refer to some restrictions when adding column.

answered Nov 3, 2011 at 8:44

slkorolev

6,0111 gold badge32 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

slkorolev Over a year ago

In my app I ended up with renaming old table and creating the new one. Though it's always possible to create new columns and not use old ones. As you can see SQLite by definition does not have options to delete or to update individual column.

Collectives™ on Stack Overflow

Android Database add column

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related