About
Storage
SQLite is different from most of the database in that it stores the schema (metadata) in the sqlite_schema table as the original text of the CREATE statements that define the schema.
List
Select the tables
SELECT name FROM sqlite_master WHERE type='table'
Get info on a table
PRAGMA table_info(TableName)