rename column of sqlite database when upgrade database_version

Question

how can rename column of table in SQlite database android when upgrade database_version

  @Override
    public void onUpgrade(SQLiteDatabase db, int i, int i1) {
        if (DATABASE_VERSION == 2) {
           ????
        }

        onCreate(db);
    }

Possible duplicate of Android Room: How to Migrate Column Renaming? — Nicola Gallazzi
– Nicola Gallazzi, Commented Sep 17, 2019 at 12:50
@NicolaGallazzi it is obvious that the OP is not using ROOM. — forpas
– forpas, Commented Sep 17, 2019 at 13:00
@forpas, sure thing, my bad! However Room is not the point here, as the SQLite syntax would be the same — Nicola Gallazzi
– Nicola Gallazzi, Commented Sep 17, 2019 at 13:35
i dont want migrate and rename table or alter or add column .forexample my column name in last version was a and in new version will be b. i want rename column in onUpgrade method without clear table or clear last version of application — mahsa k
– mahsa k, Commented Sep 18, 2019 at 18:21

forpas · Accepted Answer · 2019-09-17 12:58:59Z

2

With ALTER TABLE you can change the column's name (version of SQLite: 3.25.0+):

if (DATABASE_VERSION == 2) {
    db.execSQL("alter table tablename rename columnname to newcolumnname");
}

answered Sep 17, 2019 at 12:58

forpas

165k10 gold badges51 silver badges85 bronze badges

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

2 Comments

mahsa k Over a year ago

thanks for your solution .it means i should renam column dynamically iwith this code?

forpas Over a year ago

Replace columnname and newcolumnname with the current and the new name of the column.

Collectives™ on Stack Overflow

rename column of sqlite database when upgrade database_version

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related