So, I dived into SQLite.
Showing tables: .tables
Showing a command which was used to create a table: .schema <table_name>
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: