SELECT name
FROM sqlite_master
WHERE type = 'table'
ORDER BY name;
SELECT
m.name AS table_name,
p.name AS column_name,
p.type AS column_type,
p.notnull,
p.dflt_value,
p.pk
FROM sqlite_master AS m
JOIN pragma_table_info(m.name) AS p
WHERE m.type = 'table'
AND m.name NOT LIKE 'sqlite_%'
ORDER BY m.name, p.cid;
EXEC