SQLite Forum

Reset database
Is there an SQL i.e. a programmatic way to reset a database to the same state as it was when it was created?

I can do this by deleting the file and recreating the database with sqlite3_open.

But I am pre-empting failure when I have just read access to the database; hence the question.