Cheat Sheet logoCheat Sheet Today
SQLite CLI and Shell Cheatsheet/Show column headers

Enable headers in tabular output.

Back to sheetBrowse commands
Sign in to save
Section: Output, import, and export

Show column headers

text
text
.headers on
Explanation

Often paired with `.mode column` for human-readable query results.

View in sheet →

Learn the surrounding workflow

Compare similar commands or jump into common fixes when this command is part of a bigger troubleshooting path.

Compare commandsView fixes

Related commands

Same sheet · prioritizing Output, import, and export
Write the next query result to a file
Send one result set to a file without changing subsequent output.
OpenIn sheettextsame section
Use aligned column output
Render query results in a readable table.
OpenIn sheettextsame section
Export rows as CSV
Switch output mode to CSV.
OpenIn sheettextsame section
Import a CSV file into a table
Load rows from CSV using the shell importer.
OpenIn sheettextsame section
Execute SQL from a file
Run a script inside the shell.
OpenIn sheettextsame section
Dump the full database as SQL
Export schema and data as executable SQL.
OpenIn sheettextsame section