SQLite Forum

Resetting id count
I am playing with SQLite as described in "Main Topic and Non Main Topics".

I have to try out a lot. For this I need to delete the old tables.
I could do that with:
    DROP TABLE [IF EXISTS] [schema_name.]table_name;

The problem with this is that it does not reset the id count of the primary keys.
In this case not a problem, I just throw away the complete db and start with a new one.
But what if that is not an option? How can I reset the id count?