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.

This is the correct command: `drop table if exists tablename` — juergen d, Jan 06 '18 at 18:07

score 8 · Accepted Answer · answered Jan 06 '18 at 18:11

8

Drop your Table by using following code

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

answered Jan 06 '18 at 18:11

Subin Babu

1,515
2
24
50

score 0 · Answer 2 · edited Jun 14 '19 at 18:25

0

Correct Syntax:

DROP TABLE IF EXISTS

Incorrect Syntax:

DROP IF TABLE EXISTS

edited Jun 14 '19 at 18:25

kenlukas

3,616
9
25
36

answered Jun 14 '19 at 16:13

Frank White

1

Android Studio Error in SQLiteDatabase - Drop if table exists

2 Answers2