sqlite truncate table

It is the two step process:

1. Delete all data from that table using:

   Delete from TableName
   

2. Then:

   DELETE FROM SQLITE_SEQUENCE WHERE name='TableName';
   

source: stackoverflow.com/questions/4…