/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 vote174 views1 answer
Drop domain postgresql
SQL
0 vote208 views1 answer
Connect google bigquery connect using sqirrel
SQL
0 vote136 views1 answer
Concatenate columns in table
SQL
8 votes162 views1 answer
Alter tablespace add datafile autoextend
SQL
11 votes137 views3 answers
How to get last row of table in sql
SQL
0 vote143 views1 answer
Aktor yang pernah terlibat di film bergenre Aksi di sql
SQL
-1 vote129 views1 answer
Add column alter table default value
SQL
3 votes136 views1 answer
DB: in eloquent using sql
SQL
4 votes153 views3 answers
Is not null sql
SQL
1 vote145 views2 answers
How to drop a unique constraint in sql
SQL