On 8/15/19, Jose Isaias Cabrera <[email protected]> wrote: > I have no idea > what that means, but the question I have is, will that number ever change? > Thanks.
Yes. Root page numbers will change, for example when you run VACUUM. An SQLite database consists of a "forest" of b-trees. Each table and each index is a separate b-tree. Each b-tree has a root page. All other pages of the b-tree are descended from the root page. The sqlite_master table identifies the page number of the root of each b-tree. The sqlite_master table itself is also a b-tree which is always rooted on page 1. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
