Welcome to the SQLitening support forums!
Started by Fredrick Ughimi, August 02, 2011, 03:39:14 pm
QuoteThe normal ROWID selection algorithm described above will generate monotonically increasing unique ROWIDs as long as you never use the maximum ROWID value and you never delete the entry in the table with the largest ROWID. If you ever delete rows or if you ever create a row with the maximum possible ROWID, then ROWIDs from previously deleted rows might be reused when creating new rows and newly created ROWIDs might not be in strictly ascending order.
QuoteBut I discovered in SQlite Expert Personal that the RowID is regenerated each time a record is deleted.
QuoteThe VACUUM command may change the ROWIDs of entries in any tables that do not have an explicit INTEGER PRIMARY KEY.