Sometimes you might want to check your “dot command” existing settings in the SQLite command line interface.

Fortunately there’s a .show dot command that returns various settings and their current values.

Example

Here’s an example of using the .show command.

.show

Result:

        echo: off
         eqp: off
     explain: auto
     headers: on
        mode: column
   nullvalue: ""
      output: stdout
colseparator: "|"
rowseparator: "\n"
       stats: off
       width: 20 20 
    filename: Pets.db

So it’s not a large list, but it covers some of the more common settings.

Let’s change a few settings and then run .show again.

.headers off
.mode csv
.nullvalue NULL
.show

Result:

        echo: off
         eqp: off
     explain: auto
     headers: off
        mode: csv
   nullvalue: "NULL"
      output: stdout
colseparator: ","
rowseparator: "\r\n"
       stats: off
       width: 20 20 
    filename: Pets.db

Notice that by setting .mode to csv, the colseparator and rowseparator settings are also changed.