Remove all table rows from SQLite database table
Just do:
db.delete(DATABASE_TABLE, null, null);Note that using rawQuery should work, but can be a potential security risk.
EDIT:
About the problem you have when you use
db.execSQLRead the documentation, it says you should not use execSQL with INSERT, DELETE, UPDATE or SELECT
Consensus is to drop and recreate the table, or you can use DELETE FROM tbltask which uses a performance operation similar to a TRUNCATE on other dbs.
getWritableDatabase().execSQL("DELETE FROM " + "contacts" + ";");Here contacs is my table name.. Try it..It works for me..