title: SQLite Drop and Recreate Table
body: <p>How do I drop and recreate a table with updated information? </p>
  
  <p>For example; I have a table in my application with 5 records. </p>
  
  <pre><code>ID     Entry
  1      a
  2      b
  3      c
  4      d
  5      e
  </code></pre>
  
  <p>Now when I delete a record lets say, ID 3 the table becomes</p>
  
  <pre><code> ID     Entry
  1      a
  2      b
  4      d
  5      e
  </code></pre>
  
  <p>How can I drop it, and recreate it to become this:</p>
  
  <pre><code>  ID     Entry
  1      a
  2      b
  3      d
  4      e
  </code></pre>
  
  <p>Actually the deletion is controlled by the user so any record can be deleted at any time. </p>