title: sqlite rowid after deleting rows
body: <p>I created sqlite table tmp with columns id,name.</p>
  
  <pre><code>CREATE TABLE if not exists tmp (
              id             INTEGER PRIMARY KEY,
              name            TEXT NOT NULL);
  </code></pre>
  
  <p>I inserted 5 rows in it.</p>
  
  <p>When I run select query with rowid column it gives below output.</p>
  
  <pre><code>select rowid,id,name from tmp;
  
  rowid  id    name
  1      1     a
  2      2     b
  3      3     c
  4      4     d
  5      5     e
  </code></pre>
  
  <p>Now I delete rows with id 3 and 4 and run above query again.</p>
  
  <pre><code>rowid  id    name
  1      1     a
  2      2     b
  5      5     e
  </code></pre>
  
  <p>Now my problem is rowid not getting reset and holes.</p>
  
  <p>Even after doing vacuum, it still doesnt reset rowid, it still gives above output.</p>
  
  <p>The output which I want is</p>
  
  <pre><code>rowid id  name
  1      1  a
  2      2  b
  3      5  e
  </code></pre>
  
  <p>Can anybody help me in achieving above output?</p>
  
  <p>Thanks</p>