The sqlite_master view outlines the details of all the database objects within SQLite. In SQLite, the maximum size for a database would be 2,147,483,646 pages at 65,536 bytes per page or 140,737,488,224,256 bytes (about 140 terabytes), While the minimum size for an SQLite database is a single 512-byte page. The best way to see which tables exist is by performing an SQL statement on the master table, as shown in the following set of commands:

Effectively, download the sqlite3_analyzer program from the SQLite website. The program performs many functions, such as interrogating the database file and outputs a summary in text format showing the database structure, its environment, tables, indexes, the page sizes, entries, storage in bytes consumed, pages used, overflow pages, and unused bytes on primary pages.

The amount of detail available is impressive and useful when it comes to analyzing resources, components, and structure of a database.

The sqlite3_analyzer program...