Schema Browser

All database objects are listed in this widget. Objects are grouped into logical tree. Available actions for the chosen tree item (table, index, view etc.) are dynamically shown in the Context Menu in the menu bar or in the pop-up menu (right mouse click).

Schema Browser (Object Tree)

Pragma Editor

The database parameters can be viewed and changed in the Pragma Editor. All modifiable non-deprecated PRAGMAs are listed in the table. The PRAGMA case_sensitive_like cannot be read in the normal way, so Sqliteman executes a bit of SQL code to determine its current value. Executing a PRAGMA statement in the SQL Editor will update the displayed PRAGMA values. The currently selected PRAGMA can also be changed by overwriting the contents of the editable value box and clicking on the Update Value button.

Warning

Every PRAGMA change affects the behavior of the database. You should know what are you doing here.

Pragma editor