title: How to reset the Primary key and delete the SQLite Db created
body: <p>This code will create the Database in : LocalFolder</p>
  
  <pre class="lang-cs prettyprint-override"><code>string DBPath = Path.Combine(Windows.Storage.ApplicationData.Current.LocalFolder.Path, "customers.sqlite");
  using (var db = new SQLite.SQLiteConnection(DBPath))
  {
      // Create the tables if they don't exist
      db.CreateTable&lt;Customer&gt;();
      db.CreateTable&lt;Item&gt;();
  }
  </code></pre>
  
  <p>The problem:</p>
  
  <ol>
  <li>The code below here will not reset the Primary Key to 0 (or starting number ) for each of the table Once each of them has been used before. Is this code only empty the table but not reset the Primary Key?</li>
  </ol>
  
  <p>How to delete the customers.sqlite ( Database created ) so that this will reset all Primary Key to starting number like 0.</p>
  
  <pre class="lang-cs prettyprint-override"><code>using (var db = new SQLite.SQLiteConnection(DBPath))
  {
      db.DeleteAll&lt;Customer&gt;();
      db.DeleteAll&lt;Item&gt;();
  }
  </code></pre>