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.