I have an iphone app that is using a SQLite database, everything works and I can save the database to file and load it back up when the app is reloaded. But the problem i'm having is that I don't know how I can clear the database and start over from scratch.
I have tried deleting the database file, doing so will cause the app to start a new database from scratch the next time the app is restarted however I would like to know how to not just delete the database file but to also clear it out of memory all together and start a new database without needing to restart the app.