SQLite Reset Primary Key Field

by

Try this:

delete from your_table;    
delete from sqlite_sequence where name="your_table";

SQLite Autoincrement

SQLite keeps track of the largest
ROWID that a table has ever held using
the special SQLITE_SEQUENCE table. The
SQLITE_SEQUENCE table is created and
initialized automatically whenever a
normal table that contains an
AUTOINCREMENT column is created. 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.

More Related Contents:

  1. Selecting more than one value
  2. Is it possible to insert multiple rows at a time in an SQLite database?
  3. SQLite DateTime comparison
  4. SQLite INSERT – ON DUPLICATE KEY UPDATE (UPSERT)
  5. How do I dump the data of some SQLite3 tables?
  6. Deleting duplicate rows from sqlite database
  7. SQLite – How do you join tables from different databases?
  8. What does the SQL Standard say about usage of backtick(`)?
  9. Declare variable in SQLite and use it
  10. Does SQLite3 not support foreign key constraints?
  11. How to get a list of column names on Sqlite3 database?
  12. Query to get records based on Radius in SQLite?
  13. How do I add a foreign key to an existing SQLite table?
  14. How to use SQL Order By statement to sort results case insensitive?
  15. Sqlite: CURRENT_TIMESTAMP is in GMT, not the timezone of the machine
  16. Is there AUTO INCREMENT in SQLite?
  17. GROUP_CONCAT in SQLite
  18. How do I import .sql files into SQLite 3?
  19. Match only entire words with LIKE?
  20. sqlite equivalent of row_number() over ( partition by …?
  21. What is causing Foreign Key Mismatch error?
  22. Android multiple databases open
  23. How to split comma-separated values?
  24. sqlite select with condition on date
  25. How to compare sqlite TIMESTAMP values
  26. SQlite: select into?
  27. SQLite Order By Date1530019888000
  28. SQL – Inserting a row and returning primary key
  29. IF() statement alternative in SQLite
  30. Copy table structure to new table in sqlite3

Leave a Comment