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 can also be used in a variety of ways to use the statistics gained from using it. sqlite3_analyzer is a TCL script and is available at http://www.sqlite.org/src/artifact/8e50b217c56a6a08.