title: iphone - how to clear SQLite database?
body: <p>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.</p>
  
  <p>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.</p>