Name

.headers — Control display of column names and headers

Common Usage

.headers switch

Description

The .headers command controls the display of column names and headers. If on, sqlite3 will generate a row of column names before displaying any output. In some modes, a separator between the column names and the resulting data will also be displayed.

The default is off.

Get Using SQLite now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.