/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 vote195 views1 answer
Connect postgresql using a connection string
SQL
0 vote200 views1 answer
Openquery insert into linked server
SQL
0 vote189 views1 answer
Rollback to name in sql
SQL
0 vote216 views1 answer
Manage Database in MySQL
SQL
0 vote200 views1 answer
Alter table myisam to innodb
SQL
0 vote228 views1 answer
Postgresql stored procedure update table values
SQL
0 vote231 views1 answer
Create table like sql
SQL
6 votes240 views3 answers
Rename column ORACLE
SQL
0 vote221 views1 answer
Updating database in sql
SQL
0 vote214 views1 answer
Sql log file inof
SQL