/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

4 votes188 views1 answer
Phone number sql
SQL
31 votes191 views3 answers
SQL Server change column data type
SQL
2 votes185 views1 answer
Update trigger
SQL
3 votes195 views1 answer
Increment integer in table sql
SQL
5 votes192 views2 answers
Oracle apex debug mode
SQL
1 vote179 views1 answer
Group_concat max length mysql
SQL
0 vote296 views1 answer
Mysql edit trigger
SQL
2 votes210 views1 answer
Find column in all stored procedures sql server
SQL
7 votes176 views3 answers
How ot change name of column mysql
SQL
4 votes183 views2 answers
Mysql select where starts with
SQL