SQLite Forum

Suggestion a new dot command (.map)
Login
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