SQLite Forum

Are you asking about the AUTOINCREMENT values for the INTEGER PRIMARY KEY?

You reset that by clearing the entry from the "sqlite_sequence" table:

~~~~~
   DELETE FROM [schema_name.]sqlite_sequence WHERE name='table_name';
~~~~~