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