Let's combine:

• sqlite_master, which returns the list of objects,

• pragma_table_info('yourtable'), which returns the list of columns for the table yourtable

Result :

WITH sm AS (SELECT name FROM sqlite_master WHERE type = 'table')
SELECT * FROM PRAGMA_TABLE_INFO(sm.name), sm ORDER BY sm.name, 1;