Also see How to get schema of SQLite3 table in Python
You can use the .schema
command to show the SQL CREATE
statement for a specific table in a SQLite3 database file using the sqlite3
command line tool:
sqlite3 [database file] ".schema (table name)"
for example:
sqlite3 /usr/share/command-not-found/commands.db ".schema commands"