title: SQLite Reset Primary Key Field
body: <p>I have a few tables in SQLite and I am trying to figure out how to reset the auto-incremented database field. </p>
  
  <p>I read that <code>DELETE FROM tablename</code> should delete everything and reset the auto-incremement field back to <code>0</code>, but when I do this it just deletes the data.  When a new record is inserted the autoincrement picks up where it left off before the delete.</p>
  
  <p>My <code>ident</code> field properties are as follows:</p>
  
  <ul>
  <li><strong>Field Type</strong>: <code>integer</code></li>
  <li><strong>Field Flags</strong>: <code>PRIMARY KEY</code>, <code>AUTOINCREMENT</code>, <code>UNIQUE</code></li>
  </ul>
  
  <p>Does it matter I built the table in SQLite Maestro and I am executing the <code>DELETE</code> statement in SQLite Maestro as well?</p>
  
  <p>Any help would be great.</p>