ContextQMD
Back to Materialize

ALTER SYSTEM SET

doc/user/content/sql/alter-system-set.md

123885 B
Original Source

Use ALTER SYSTEM SET to globally modify the value of a configuration parameter.

To see the current value of a configuration parameter, use SHOW.

Syntax

mzsql
ALTER SYSTEM SET <config> [TO|=] <value|DEFAULT>
Syntax elementDescription
<config>The name of the configuration parameter to modify.
<value>The value to assign to the configuration parameter.
DEFAULTReset the configuration parameter's default value. Equivalent to ALTER SYSTEM RESET.

{{% include-headless "/headless/configuration-parameters" %}}

Privileges

The privileges required to execute this statement are:

{{% include-headless "/headless/sql-command-privileges/alter-system-set" %}}