title: dropping table vs removing its content sqlite
body: <p>in my application I have to delete whole contents of a table and refill it many times</p>
  
  <p>in that case I have two solutions :</p>
  
  <p>1- drop , recreat and fill the table</p>
  
  <pre><code>"DROP TABLE IF EXISTS TABLE_NAME"
  </code></pre>
  
  <p>2- remove all its contents and refill it</p>
  
  <pre><code>"DELETE FROM TABLE_NAME"
  </code></pre>
  
  <p>now which solution more effective?</p>