Set start value for AUTOINCREMENT in SQLite

by

From the SQLite web site:

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.

I tried this, and it works:

UPDATE SQLITE_SEQUENCE SET seq = <n> WHERE name="<table>"

Where n+1 is the next ROWID you want and table is the table name.

More Related Contents:

  1. How do I rename a column in a SQLite database table?
  2. How do I check in SQLite whether a table exists?
  3. Accessing an SQLite Database in Swift
  4. Import CSV to SQLite
  5. Select random row from a sqlite table
  6. How to get Top 5 records in SqLite?
  7. Insert new column into table in sqlite?
  8. How do you enable LIMIT for DELETE in SQLite?
  9. Sqlite primary key on multiple columns
  10. How to create custom functions in SQLite
  11. SQLite: How do I save the result of a query as a CSV file?
  12. What is the difference between SQLite integer data types like int, integer, bigint, etc.?
  13. How to generate all dates between two dates
  14. SQLITE_BUSY The database file is locked (database is locked) in wicket
  15. Does it matter what extension is used for SQLite database files?
  16. SQLite “INSERT OR REPLACE INTO” vs. “UPDATE … WHERE”
  17. How do I DROP a constraint from a sqlite (3.6.21) table?
  18. Sqlite over a network share [closed]
  19. SQLite table constraint – unique on multiple columns
  20. Is there a boolean literal in SQLite?
  21. Case sensitive and insensitive like in SQLite
  22. How to have an automatic timestamp in SQLite?
  23. svn cleanup: sqlite: database disk image is malformed
  24. Truncate a SQLite table if it exists?
  25. SELECT INTO statement in sqlite
  26. How to display blob value using x’abc’ binary string literal syntax?
  27. Unable to load DLL sqlite3 in Universal Windows App running on Mobile
  28. Integration Testing Entity Framework code first with in-memory database
  29. DbFunctions.TruncateTime LINQ equivalent in EF CORE
  30. How to get the last index of a substring in SQLite?

Leave a Comment