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?