/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 vote135 views1 answer
Best practive to pass multiple table to stored procedure in sql server
SQL
0 vote116 views1 answer
Check if a word appears at the end sql query
SQL
0 vote236 views1 answer
Why do we need data structure in sql
SQL
0 vote134 views1 answer
Sql python hwo to pass a list in paramerter
SQL
10 votes123 views1 answer
Query to find object dependencies in oracle
SQL
0 vote124 views1 answer
Low level operator in dbms
SQL
7 votes149 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
0 vote132 views1 answer
Trigger vérifier stock
SQL
0 vote123 views1 answer
Sql sort ages
SQL
0 vote135 views1 answer
Create database like
SQL