title: Deleting a SQLite database created with the sqldf library in R
body: <p>Hi I have the same question as this post
  <a href="https://stackoverflow.com/questions/16593364/how-do-you-explicitly-delete-a-sqlite-database-created-with-the-sqldf-library-in">How do you explicitly delete a SQLite database created with the sqldf library in an R script</a></p>
  
  <p>However, the user found the answer in a blog and put the link up but the link no longer works. Like the user, I don't understand where tables are stored and can't delete them. I've used the following commands with no success</p>
  
  <pre><code>sqldf("attach 'mydb' as new")
  sqldf("create table mytable as SELECT * FROM mytable1", dbname="mydb")
  file.remove("mytable")
  sqldf("drop table mytable", dbname="mydb")
  </code></pre>
  
  <p>I get the error "sqldf: table mytable1 already in mydb" </p>