CODEWITHSUNDEEP
androiddatabasesqlite
Waypoint
Waypoint

Reputation: 17753

Android Database add column

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

Upvotes: 0

Views: 916

Answers (1)

slkorolev
slkorolev

Reputation: 6001

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

Upvotes: 1

Related Questions