/SQL/Android sqlite add column if not exists

Android sqlite add column if not exists

Cursor cursor = database.rawQuery("SELECT * FROM MY_TABLE", null); // grab cursor for all data
int deleteStateColumnIndex = cursor.getColumnIndex("MISSING_COLUMN");  // see if the column is there
if (deleteStateColumnIndex < 0) { 
    // missing_column not there - add it
    database.execSQL("ALTER TABLE MY_TABLE ADD COLUMN MISSING_COLUMN int null;");
}

Similar codes

5 votes122 views1 answer
How to get all table names in sql query
SQL
1 vote126 views2 answers
Sqlstate[hy000]: general error: 1005 can't create table (errno: 150 "foreign key constraint is incorrectly formed")
SQL
1 vote113 views1 answer
Give a column name to values generated from case statement in sql
SQL
0 vote104 views4 answers
First max salary in sql
SQL
0 vote106 views1 answer
Sql composite key
SQL
0 vote116 views1 answer
Postgresql auto increment not working
SQL
0 vote124 views3 answers
Mysqli count down
SQL
1 vote102 views1 answer
How to delete a record from sqlite in android
SQL
0 vote104 views1 answer
Sql pivot without aggregate
SQL
5 votes114 views1 answer
Oracle columns in all_tables
SQL