I am using SQLite 3. I have deleted all of the rows of a member table
but one. The one row that remains is for the administrative user and
has an id of 0. I’d sure like to zero out the autoincrement counter.
The documentation for SQLite contains the following warning:
The content of the SQLITE_SEQUENCE table can be modified using
ordinary UPDATE, INSERT, and DELETE statements. But making
modifications to this table will likely perturb the AUTOINCREMENT key
generation algorithm. Make sure you know what you are doing before you
undertake such changes.
OK. I have been warned. It certainly seems like an easy procedure.
The thing about perturbing, “the AUTOINCREMENT key generation
algorithm” scares me. Do I really need to be concerned? Is there a
better way to accomplish this objective?
Thanks for any input.