Name

.explain — Format output for EXPLAIN SQL command

Common Usage

.explain [switch]

Description

The .explain command sets several sqlite3 parameters (such as mode and column width), making it easier to view the output from any EXPLAIN SQL commands. When turned off, the previous settings are restored. If no parameter is given, the explain mode will be turned on. Turning explain on when it is already on resets all shell parameters to the default explain mode.

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.