Configuration
DuckDB has a number of configuration options that can be used to change the behavior of the system.  
The configuration options can be set using either the [`SET` statement](#docs:sql:statements:set) or the [`PRAGMA` statement](#docs:configuration:pragmas).
They can be reset to their original values using the [`RESET` statement](#docs:sql:statements:set::reset).  
The values of configuration options can be queried via the [`current_setting()` scalar function](#docs:sql:functions:utility) or using the [`duckdb_settings()` table function](#docs:sql:meta:duckdb_table_functions::duckdb_settings). For example:  
```sql
SELECT current_setting('memory_limit') AS memlimit;
SELECT value AS memlimit FROM duckdb_settings() WHERE name = 'memory_limit';
```