Android Studio Error in SQLiteDatabase - Drop if table exists

Question

The following code

@Override
    public void onUpgrade(SQLiteDatabase db, int i, int i1) {
        db.execSQL("DROP IF TABLE EXISTS " + TABLE_NAME);
        onCreate(db);
    }

always gives an error index table trigger or view got if

Why is that? I hope anyone can help me.

Answer 1

Drop your Table by using following code

db.execSQL("DROP TABLE IF EXISTS " + YOUR_TABLE);