Name

page_count — Return total number of pages in a database

Common Usage

PRAGMA [database.]page_count;

Description

The page_count pragma returns the current number of pages in database . The page count includes all pages in the file, including free pages. The size of the database file should be page_count * page_size.

See Also

max_page_count, page_size, cache_size, freelist_count

Get Using SQLite now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial