How can I reset a autoincrement sequence number in sqlite

by

Building on Marcos Vasconcelos’ answer:

UPDATE sqlite_sequence SET seq = (SELECT MAX(col) FROM Tbl) WHERE name="Tbl"

This query will set seq to the largest value in the col identity column in the Tbl table, so there is no risk of violating constraints.

More Related Contents:

  1. Android Cursor with ORMLite to use in CursorAdapter
  2. I am getting this error on my code [closed]
  3. Sqlite for Android
  4. How can I avoid concurrency problems when using SQLite on Android?
  5. How to store(bitmap image) and retrieve image from sqlite database in android? [closed]
  6. Best way to work with dates in Android SQLite [closed]
  7. How do I join two SQLite tables in my Android application?
  8. How can I create a user-defined function in SQLite?
  9. SQLite Android Database Cursor window allocation of 2048 kb failed
  10. Android SQLite: Update Statement
  11. How to delete SQLite database from Android programmatically
  12. How do I create a database in android? [closed]
  13. Android SimpleCursorAdapter doesn’t update when database changes
  14. How to implement Export sqlite To excel/csv file in android?
  15. How to store and retrieve a byte array (image data) to and from a SQLite database?
  16. problem about sqlite database, no such table:
  17. SQLite Query in Android to count rows
  18. Using the LIMIT statement in a SQLite query
  19. sqlite encryption for android
  20. Retrieve large blob from Android sqlite database
  21. Attempt to reopen an already-closed object sqlitedatabase
  22. How insert image in room persistence library?
  23. How to access an existing sqlite database in Android?
  24. DB File in Assets Folder. Will it be Updated?
  25. How to store JSON object in SQLite database
  26. sqlite3: not found
  27. Android SQLiteOpenHelper cannot open database file
  28. Getting the type of a column in SQLite
  29. Android table creation Failure (near “autoincrement”: syntax error)?
  30. sqlite insert into table select * from

Leave a Comment