[sqlite] Are columns declared as 'INTEGER PRIMARY KEY' guaranteed not to change except from UPDATE statements?

Thanks a lot both Igor and Simon for the quick response! Your two answers settle my doubts. On Mon, Nov 16, 2015 at 3:48 PM, Simon Slavin wrote: > On 16 Nov 2015, at 12:24am, Randy Eels wrote: > > > My main question is: is an 'INTEGER PRIMARY KEY' column guaranteed not to

[sqlite] Are columns declared as 'INTEGER PRIMARY KEY' guaranteed not to change except from UPDATE statements?

Using SQLite 3.8.7.1. Here and elsewhere is mentioned that the official SQLite documentation includes the line Rowids can