How can i rename column and doing a room migration on Android

I am trying to do a migration using room and rename column name:

That's my code

private val MIGRATION_FROM_3_TO_4 = {              object : Migration(3, 4) {                  override fun migrate(database: SupportSQLiteDatabase) {                      database.execSQL("ALTER TABLE Contacts RENAME Name TO contact_name")                     database.execSQL("ALTER TABLE People RENAME Name TO person_name")                  }              }          }    Output:    android.database.sqlite.SQLiteException: near "Name": syntax error (code 1): , while compiling: ALTER TABLE Contacts RENAME Name TO contact_name.  

How can anyone help me please?

https://stackoverflow.com/questions/66485197/how-can-i-rename-column-and-doing-a-room-migration-on-android March 05, 2021 at 08:53AM