So, I dived into SQLite.
Showing a command which was used to create a table:
Showing an actual structure/info about table:
PRAGMA TABLE_INFO(<table_name>); - note that this is a SQL command.
The most human-readable mode of output, I think, is done by this:
> .header on
> .mode column
Clearing screen on Linux: