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.