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?
-- 
Igor Tandetnik

_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to