SQLite | SQLite Commands | Viewing Current Settings (.show Command)

Tags:

• SQLite
• Database

The .show command displays the current values of various settings, such as output destinations and delimiters. This article explains how to use the command.

Using the .show Command

Run .show to display the current values of the available settings.

.show

Let’s see the output.

.show

sqlite> .show
        echo: off
         eqp: off
     explain: auto
     headers: off
        mode: list
   nullvalue: ""
      output: stdout
colseparator: "|"
rowseparator: "\n"
       stats: off
       width: 
    filename: mydb.sqlite3
sqlite> 

The output above lists the settings that can be inspected with .show and their current values.

Now change the mode setting. Use the .mode Command to change it.

.mode html

sqlite> .mode html
sqlite> 

Run .show again to inspect the settings.

.show

sqlite> .mode html
sqlite> 
sqlite> .show
        echo: off
         eqp: off
     explain: auto
     headers: off
        mode: html
   nullvalue: ""
      output: stdout
colseparator: "|"
rowseparator: "\n"
       stats: off
       width: 
    filename: mydb.sqlite3
sqlite> 

The output confirms that the value of mode has changed.