TechOverflow Logo
TechOverflow

How to show table schema for SQLite3 table on the command line

Also seeHow 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:

show_schema.sh
sqlite3 [database file] ".schema (table name)"

for example:

show_schema_example.sh
sqlite3 /usr/share/command-not-found/commands.db ".schema commands"
Check out similar posts by category: SQLite