/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

9 votes218 views2 answers
Oracle all tables in schema
SQL
1 vote190 views2 answers
Postgresql remote connect
SQL
0 vote214 views1 answer
Get created time of database psql 8
SQL
0 vote239 views2 answers
Soql last year
SQL
2 votes220 views1 answer
Sql OR
SQL
1 vote190 views1 answer
Oracle list constraints
SQL
1 vote229 views1 answer
Join to find results not in another table
SQL
13 votes189 views2 answers
Sqlite rename column
SQL
0 vote216 views1 answer
Oracle execute package dblink
SQL
4 votes184 views1 answer
Force drop all tables postgres
SQL