On 8/15/19, Jose Isaias Cabrera <jic...@outlook.com> 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 d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
