How read Table Structure from Database

[Larz60+]

you didn't say the DBMS name.
Most have a way to display the schema.
If sqlite3:
install sqlite3, on Linux Mint, use:

sudo apt install sqlite3

You will have to look up command for other systems, see: https://sqlite.org/download.html

from command line:

• sqlite3 yourdbname
  
• sqlite> .output 'schema.txt'
  
• sqlite> .schema
  
• sqlite> .quit