can we use truncate query in android sqlite
If I have to truncate a table, I simply drop and recreate it.
Documentation ( http://www.sqlite.org/lang_delete.html ):
When the WHERE is omitted from a DELETE statement and the table being deleted has no triggers, SQLite uses an optimization to erase the entire table content without having to visit each row of the table individually. This "truncate" optimization makes the delete run much faster.
DELETE FROM tablename
VACUUM
Ex:
db.execSQL("DELETE FROM " + TABLE_NAME);
db.execSQL("VACUUM");
Note: this won't reset the row numbering for rows using AUTOINCREMENT. For that you'll need to drop the table and recreate it.
source: http://phpcode.mypapit.net/how-to-truncate-table-in-sqlite-database/49/