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.
SELECT name FROM sqlite_master WHERE type='table'
PRAGMA table_info(TableName)