On Thu, Aug 11, 2011 at 11:14 PM, Igor Tandetnik <itandet...@mvps.org> wrote:
> On 8/11/2011 1:35 PM, Abhinav Upadhyay wrote:
>> The documentation page of the VACUUM command says that "The VACUUM
>> command may change the ROWIDs of entries in any tables that do not
>> have an explicit INTEGER PRIMARY KEY." So what are the possible cases
>> in which the ROWIDs might change ?
>
> ROWIDs might possibly change if the table doesn't have an explicit
> INTEGER PRIMARY KEY column, and you run VACUUM commad on the database
> containing this table. Which part of the statement you quoted do you
> find unclear?
I wanted to know, why would the ROWID change, but Simon's answer makes sense.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
