Suggestion for a new CLI dot command (may be .map) to produce the table below: 1.to promote at-a-glance familiarisation with any given database database. 2.to assist in the enumeration of column names in SQL statements 3.(may be even an aid to manual version control over time) <b>Column Name</b>|<b>Description</b> AtDate|Current timestamp dbname|Fully qualified database name tid|Ordinal position of table tbl_name|Table name tbl_type|Table type [table or view] cid|Ordinal position of column in table col_name|Column name col_type|Colum type nullable|Column acceps null? dflt_value|Column default value pk|Primary key? ``` ```` <b>AtDate</b> | |<b>dbname</b> |<b>tid</b>|<b>tbl_name</b> |<b>tbl_type</b>|<b>cid</b>|<b>col_name</b> |<b>col_type</b> |<b>nullable</b>|<b>dflt_value</b>|<b>pk</b> 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 12|Table1 |table | 1|Field1 |varchar(255)| 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 12|Table1 |table | 2|Field2 |varchar(255)| 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 12|Table1 |table | 0|ID |integer | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 7|USStateAb |table | 0|Abbreviation |nvarchar | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 7|USStateAb |table | 2|Classification|nvarchar | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 7|USStateAb |table | 1|State |nvarchar | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 9|authors |table | 4|address |varchar | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 9|authors |table | 2|au_fname |varchar | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 9|authors |table | 0|au_id |varchar | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 9|authors |table | 1|au_lname |varchar | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 9|authors |table | 5|city |varchar | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 9|authors |table | 8|contract |bit | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 9|authors |table | 3|phone |char | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 9|authors |table | 6|state |char | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 9|authors |table | 7|zip |char | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 0|discounts |table | 4|discount |decimal | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 0|discounts |table | 0|discounttype |varchar | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 0|discounts |table | 3|highqty |smallint | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 0|discounts |table | 2|lowqty |smallint | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 0|discounts |table | 1|stor_id |char | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 11|employee |table | 0|emp_id |char | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 11|employee |table | 1|fname |varchar | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 11|employee |table | 7|hire_date |datetime | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 11|employee |table | 4|job_id |smallint | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 11|employee |table | 5|job_lvl |tinyint | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 11|employee |table | 3|lname |varchar | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 11|employee |table | 2|minit |char | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 11|employee |table | 6|pub_id |char | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 1|jobs |table | 1|job_desc |varchar | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 1|jobs |table | 0|job_id |smallint | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 1|jobs |table | 3|max_lvl |tinyint | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 1|jobs |table | 2|min_lvl |tinyint | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 2|publishers |table | 2|city |varchar | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 2|publishers |table | 4|country |varchar | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 2|publishers |table | 0|pub_id |char | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 2|publishers |table | 1|pub_name |varchar | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 2|publishers |table | 3|state |char | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 3|roysched |table | 2|hirange |int | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 3|roysched |table | 1|lorange |int | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 3|roysched |table | 3|royalty |int | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 3|roysched |table | 0|title_id |varchar | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 10|sales |table | 2|ord_date |datetime | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 10|sales |table | 1|ord_num |varchar | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 10|sales |table | 4|payterms |varchar | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 10|sales |table | 3|qty |smallint | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 10|sales |table | 0|stor_id |char | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 10|sales |table | 5|title_id |varchar | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 4|stores |table | 3|city |varchar | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 4|stores |table | 4|state |char | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 4|stores |table | 2|stor_address |varchar | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 4|stores |table | 0|stor_id |char | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 4|stores |table | 1|stor_name |varchar | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 4|stores |table | 5|zip |char | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 5|titleauthor|table | 0|au_id |varchar | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 5|titleauthor|table | 2|au_ord |tinyint | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 5|titleauthor|table | 3|royaltyper |int | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 5|titleauthor|table | 1|title_id |varchar | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 6|titles |table | 5|advance |money | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 6|titles |table | 8|notes |varchar | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 6|titles |table | 4|price |money | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 6|titles |table | 3|pub_id |char | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 6|titles |table | 9|pubdate |datetime | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 6|titles |table | 6|royalty |int | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 6|titles |table | 1|title |varchar | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 6|titles |table | 0|title_id |varchar | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 6|titles |table | 2|type |char | 1| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 6|titles |table | 7|ytd_sales |int | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 8|titleview |view | 2|au_lname |varchar | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 8|titleview |view | 1|au_ord |tinyint | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 8|titleview |view | 3|price |money | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 8|titleview |view | 5|pub_id |char | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 8|titleview |view | 0|title |varchar | 0| | 0 2021-01-29|15:16:31|d:\\sqlite32\\db\\pubs.db| 8|titleview |view | 4|ytd_sales |int | 0| | 0