How to add new Column to Android SQLite Database?

Question

I am facing an issue with the Android SQLite database.

I am having a table which includes one field.StudentFname and that application is working fine with Android 2.3.1 and now if I am adding another field then my application isn't working well.

Can anyone help me with this?

Answer 1

You could use ALTER TABLE function on your onUpgrade() method, like this:

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
  // If you need to add a column
  if (newVersion > oldVersion) {
     db.execSQL("ALTER TABLE foo ADD COLUMN new_column INTEGER DEFAULT 0");
  }
}

Obviously, the SQLite will be differing depending on the column definition.

Want to be a SQL expert? Come and join this SQL Certification course by Intellipaat.