SQLite: Reset AUTOINCREMENT

SQLite is storing the last ROWID within the table SQLITE_SEQUENCE that is automatically managed by SQLite. The values within this table are kept even if you delete or empty other tables.

So, you not only have to delete your table itself, but also the information stored about your table from the SQLITE_SEQUENCE meta table. You can do that for example like that:

DELETE FROM tab;
DELETE FROM sqlite_sequence WHERE name = 'tab';

Assuming the table you want to delete is called "tab". The first query would delete all data from your table, the second line would delete the entries from SQLITE_SEQUENCE. When adding new data after that, the counting will start from the beginning again.

UPDATE sqlite_sequence SET seq = 10 WHERE name = 'tab';

Alternatively, you can also change the SQLITE_SEQUENCE values individually. For instance, the query above would let the counting begin at 10.
2017-05-15 at 19:05