Greetings.
When I run this command,
sqlite> SELECT * FROM sqlite_master WHERE type='table' AND name='PMOTitles';
type|name|tbl_name|rootpage|sql
table|PMOTitles|PMOTitles|560|CREATE TABLE PMOTitles
(
TitleKey PRIMARY KEY,
Titles
)
sqlite>
I see that there is a rootpage assignment for each table. And on the help,
[1], sixth paragraph, it says, "The sqlite_master.rootpage column stores the
page number of the root b-tree page for tables and indexes." I have no idea
what that means, but the question I have is, will that number ever change?
Thanks.
josé
[1] https://sqlite.org/fileformat.html
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
