Skip to content

Database Options

SQLite has a number of options that can be tweaked on a per-database basis.

Some of these options can only be set once, when the file is created. Others can be changed at will.

Info

These options are managed via PRAGMA statements. The SQLite documentation contains a detailed description of how each of them works.

Database options view

Selecting a database in the sidebar will show the available options for the current database. Selecting an option will show a description of what it does and any available options if it can be changed.

If available, there will also be a link to the SQLite documentation for each option.

Note

  • Not all options can be changed, some are for reference only.
  • Some options are not remembered once the database is closed and need to be set each time. This is an intentional part of SQLite.