Some of this information is not stored by SQLite (AtDate, column descriptions). Other parts of this information can be obtained using these commands

.databases PRAGMA schema.table_xinfo(table_name)

Do you have some specific reason to want the information in that format ?

Do you have some specific reason to want the information in that format ?

ALL the information is generated by SQLite3 table/view by table/view; there is no wizardry here.

I am of a generation who wants to see what exists rather than of the generation who find out when the need arises, especially when chasing unexpected software behaviour or when inheriting an SQLite3 application

The suggested dot command would be a time-saving convenience both for debugging and documentation, nothing more.

Pardon me. I didn't understand that the first table you included was a description of the second table, which was the subject of your comment. However, apart from having to iterate through the tables yourself, all that information is provided by the PRAGMA I listed. Perhaps I'm of the wrong generation to appreciate the advantage of having it listed all in one big table.

I find the table you have created valuable. Would you mind sharing the SQL you generate it with?

Alas, I have no SQL script, at least, no SQL script runnable from the SQLite3 CLI.

I built the table using C# calling SQLite3.DLL directly.

I can describe the process:

1. Get a list of tables:

SELECT tbl_name
FROM sqlite_master
WHERE type IN (
		'table',
		'view'
		)
	AND tbl_name NOT LIKE 'sqlite%';

with CHINOOK.DB, you will get something like this:

tbl_name
--------------
albums
artists
customers
employees
genres
invoices
invoice_items
media_types
playlists
playlist_track
tracks

2. Iterate the list with this SQL:

select datetime('now') as AtDate, 'chinook.db' as Database,* from pragma_table_xinfo('albums');

AtDate               Database    cid  name      type           notnull  dflt_value  pk  hidden
-------------------  ----------  ---  --------  -------------  -------  ----------  --  ------
2021-01-31 14:53:49  chinook.db  0    AlbumId   INTEGER        1                    1   0
2021-01-31 14:53:49  chinook.db  1    Title     NVARCHAR(160)  1                    0   0
2021-01-31 14:53:49  chinook.db  2    ArtistId  INTEGER        1                    0   0

You need to save the results in each iteration into a table.

EITHER create a table with the first iteration with:

create table dbMap as select datetime('now') as AtDate, 'chinook.db' as Database,* from pragma_table_xinfo('albums');

and append to it with subsequent iterations.

OR

Create a table in each iteration

create table tblAlbums as select datetime('now') as AtDate, 'chinook.db' as Database,* from pragma_table_xinfo('albums');

If you choose the latter method, you need to collate the individual tables:

select * from tblAlbuns
union all
....
select * from tbltracks
select * from tbl tracks

You can then redirect the output to a text file, more or less giving you what I posted here.

For the iteration, you'll need to use a programming language OR use clever recursive CTEs within the SQLiite3 CLI.