How to execute a simple SQL script line in Android

Question

I have the following command to drop all tables, to be performed in onUpgrade:

@Override
public void onUpgrade(SQLiteDatabase db, int i, int i2) {
    // Drop all tables...
    String query = "select 'drop table ' || name || ';' from sqlite_master " +
                       "where type = 'table';";
    db.rawQuery(query, null);
    onCreate(db);
}

However it doesn't seem to do anything. All my old tables are still there. How do I execute this query properly?

Seems like it would be much simpler to do it the normal way... `db.execSQL("DROP TABLE IF EXISTS " + classname.tablename);` once for each table. — Barak, Nov 29 '15 at 16:22

score 0 · Accepted Answer · edited May 23 '17 at 12:30

0

As the source of this query says:

The output of this is a script that will drop the tables for you.

But you are never looking at its output.

You have to read the output of this query, and execute every returned string.

edited May 23 '17 at 12:30

Community

1
1

answered Nov 29 '15 at 18:17

CL.

173,858
17
217
259

How to execute a simple SQL script line in Android

1 Answers1