SET and RESET Statements

Search Shortcut cmd + k | ctrl + k

Documentation / SQL / Statements

The SET statement modifies the provided DuckDB configuration option at the specified scope.

Examples

Update the memory_limit configuration value:

SET memory_limit = '10GB';

Configure the system to use 1 thread:

SET threads = 1;

Or use the TO keyword:

SET threads TO 1;

Change configuration option to default value:

RESET threads;

Retrieve configuration value:

SELECT current_setting('threads');

Set the default collation for the session:

SET SESSION default_collation = 'nocase';

Set the default sort order globally:

SET GLOBAL sort_order = 'desc';

Set the default threads globally:

SET GLOBAL threads = 4;

SET updates a DuckDB configuration option to the provided value.

The RESET statement changes the given DuckDB configuration option to the default value.

Configuration options can have different scopes:

GLOBAL: Configuration value is used (or reset) across the entire DuckDB instance.
SESSION: Configuration value is used (or reset) only for the current session attached to a DuckDB instance.
LOCAL: Not yet implemented.

When not specified, the default scope for the configuration option is used. For most options this is GLOBAL.

See the Configuration page for the full list of configuration options.