How to reset autoincrement counter in SQLite
You can use this command with your table name to do that
delete from sqlite_sequence where name='your_table';You can use this command with your table name to do that
delete from sqlite_sequence where name='your_table';