As we saw in the opening post, SQLite stores metadata about tables in a special "schema table" starting on page 1. We've been reading records from this table to list the tables in the current database, but before we can start evaluating SQL queries against user-defined tables, we need to extract more information from the schema table. For each table, we need to know: the table name the root page the name and type of each column The first two are very easy to extract, as they are directly stored ...