sqlite3 app.db 'PRAGMA table_info(users);'

Category: Databases & SQL

sqlite3 app.db 'PRAGMA table_info(users);'

Show a table's column definitions

The table_info pragma returns one row per column: name, type, nullability, default, and primary-key flag. Related: .schema users.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.