title: Deleting record from sql table and update sql table
body: <p>I am trying to delete a record in sqlite. i have four records record1, record2, record3, record 4
  with id as Primary Key.</p>
  
  <p>so it will auto increment for each record that i insert. now when i delete record 3, the primary key is not decrementing. what to do to decrement the id based on the records that i am deleting. </p>
  
  <p>i want id to be 1,2,3 when i delete the record 3 from the database. now it is 1,2,4. Is there any sql query to change it. I tried this one</p>
  
  <pre><code>DELETE FROM TABLE_NAME WHERE name = ?
  </code></pre>
  
  <p>Note: I am implementing in xcode</p>