Configuration
<!-- markdownlint-disable MD001 -->  
The `PRAGMA` statement is a SQL extension adopted by DuckDB from SQLite. `PRAGMA` statements can be issued in a similar manner to regular SQL statements. `PRAGMA` commands may alter the internal state of the database engine, and can influence the subsequent execution or behavior of the engine.  
`PRAGMA` statements that assign a value to an option can also be issued using the [`SET` statement](#docs:sql:statements:set) and the value of an option can be retrieved using `SELECT current_setting(option_name)`.  
For DuckDB's built in configuration options, see the [Configuration Reference](#docs:configuration:overview::configuration-reference).
DuckDB [extensions](#docs:extensions:overview) may register additional configuration options.
These are documented in the respective extensions' documentation pages.  
This page contains the supported `PRAGMA` settings.