title: Why does SQLITE create empty sqlite_sequence table?
body: <p>I have a database of several tables in which the first field is defined as:</p>
  
  <p>'ID' INTEGER NOT NULL UNIQUE ... PRIMARY_KEY('ID')</p>
  
  <p>I do not use the AUTOINCREMENT keyword for any of these tables yet my db contains an empty sqlite_sequence table which I cannot delete. Inserting records into these tables with a NULL value for the ID field generates default incremental values for the ID fields but does not populate or update the sqlite_sequence table. Is there any way I can reset the last inserted rowid value to 0 for these tables?</p>