/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

0 vote247 views1 answer
To_date sql
SQL
1 vote233 views1 answer
Deleting database in sql
SQL
0 vote240 views1 answer
How convert into in in sql query
SQL
0 vote235 views1 answer
Pl sql constraint user function
SQL
0 vote237 views1 answer
Sql count matching group by
SQL
0 vote255 views1 answer
Oracle dynamic select into
SQL
0 vote232 views1 answer
Acual month sql
SQL
0 vote239 views1 answer
Postgresql comandos basicos
SQL
1 vote230 views1 answer
Primary key reset in SQL database
SQL
0 vote258 views2 answers
Sql day from datetime
SQL