title: Modifying Database IDs from Rails Console?
body: <p>I have a small database and have been adding entries through a Rails page. I "destroyed" one of the entries and now my sequence of IDs are skipping by one. For example, I now have 42 then 44, instead of the obvious: 42, 43, 44.</p>
  
  <p>I was wondering if there was a way to edit the ID number of a new object through the console. I have tried:</p>
  
  <pre><code>record.id = 43
  record.save
  </code></pre>
  
  <p>and</p>
  
  <pre><code>record = record.new
  record.attributes = { :id =&gt; 43 }
  </code></pre>
  
  <p>but both didn't work. I'm fairly certain there has to be a console method for this, but I can't seem to find much specific on Google and I probably read the Rails API incorrectly... Would I possibly have to do this through direct SQL in sqlite?</p>
  
  <p>Thanks</p>