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
sqlite-users mailing list

Reply via email to