sqlite3 app.db '.schema users'

Category: Databases & SQL

sqlite3 app.db '.schema users'

Show the CREATE statement for a table

Prints the DDL that created users, including its indexes; with no argument it dumps the whole schema. Related: .tables.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.