title: How to delete a SQL database table in R
body: <p>I created a table using dbWriteTable in R (and then appended more data to it), using two commands:</p>
  
  <pre><code>dbWriteTable(my_db, name="dallas_flights", value=nov_trim, overwrite = TRUE, row.names = FALSE)
  dbWriteTable(my_db, name="dallas_flights", value=dec_trim, append = TRUE, row.names = FALSE)
  </code></pre>
  
  <p>After I ran my script, I deleted everything using rm(list=ls()). When I type, ls() into R, I get character(0).</p>
  
  <p>However, when I try to rerun the script, and reach these two commands, I get an error indicating that the table still exists:</p>
  
  <pre><code>Error in sqliteExecStatement(con, statement, bind.data) : 
  </code></pre>
  
  <p>RS-DBI driver: (error in statement: table dallas_flights already exists)</p>
  
  <p>I do not know how to delete this table. Any advice?</p>