Sqlite: How do I reset all database tables?

Question

I want a debug function to do this, but I'm unaware of whether one already exists. Going through and using 'drop table' for each of my tables will be a pain.

Help appreciated.

Answer 1

to "drop database" for sqlite, simply delete the database file (and recreate if needed)

Answer 2

Since the database is just one file, you can indeed just erase it. If you want something more automatic, you can use the following to do it all programmatically:

1. Recuperate your schema:

   SELECT group_concat(sql,';') FROM sqlite_master;

2. Disconnect from the database

3. Create your schema again with what was returned from the above query

If you used any particular options for your original database (page_size, etc), they will have to be declared manually as well.