title: Resetting Autoincrement in Android SQLite
body: <p>I have this method which will remove all rows from a table but I also want it to reset the autoincrement so that when a new row is added it will start again. The SQL statement I'm using isn't working due to certain columns not existing. Am I doing it right?</p>
  
  <pre><code>private void rmvAll() {
  
      SQLiteDatabase db = appts.getWritableDatabase();
      db.delete(TABLE_NAME, null, null);
      db.execSQL("DELETE FROM SQLITE_SEQUENCE WHERE NAME = " + TABLE_NAME);
  
  }
  </code></pre>