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?](https://stackoverflow.com/questions/52657760/android-room-how-to-migrate-column-renaming) — Nicola Gallazzi, Sep 17 '19 at 12:50
@NicolaGallazzi it is obvious that the OP is not using ROOM. — forpas, Sep 17 '19 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, Sep 17 '19 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, Sep 18 '19 at 18:21

score 2 · Answer 1 · answered Sep 17 '19 at 12:58

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 '19 at 12:58

forpas

160,666
10
38
76

thanks for your solution .it means i should renam column dynamically iwith this code? – mahsa k Sep 18 '19 at 18:16
Replace `columnname` and `newcolumnname` with the current and the new name of the column. – forpas Sep 18 '19 at 18:30

rename column of sqlite database when upgrade database_version

1 Answers1