How to Delete All Items From SQLite in Android

Your delete() call is correct. Did you get writable database? Here is example of method using delete:

/** * Remove all users and groups from database. */public void removeAll(){    // db.delete(String tableName, String whereClause, String[] whereArgs);    // If whereClause is null, it will delete all rows.    SQLiteDatabase db = helper.getWritableDatabase(); // helper is object extends SQLiteOpenHelper    db.delete(DatabaseHelper.TAB_USERS, null, null);    db.delete(DatabaseHelper.TAB_USERS_GROUP, null, null);}

db.delete(TABLE_NAME, null, null); is the correct syntax to delete all rows in a table. But I think you would have given table name directly without enclosing it in double-quotes. Try like this

db.delete("TABLE_NAME", null, null);

It might help :)

Use This Code for clear all database content

Cursor c = db.rawQuery("SELECT name FROM sqlite_master WHERE type='table'", null);String tableName="";  if (c.moveToFirst()) {      while ( !c.isAfterLast() ) {          tableName = c.getString( c.getColumnIndex("name"));          if(!tableName.equals('android_metadata')){            db.execSQL("DROP TABLE '"+tableName+"'");          }          c.moveToNext();      }  }c.close();