ContextQMD
Back to Materialize

ALTER SYSTEM RESET

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

123747 B
Original Source

Use ALTER SYSTEM RESET to globally restore the value of a configuration parameter to its default value. This command is an alternative spelling for ALTER SYSTEM SET...TO DEFAULT.

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

Syntax

mzsql
ALTER SYSTEM RESET <config>;
Syntax elementDescription
<config>The configuration parameter's name.

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

Privileges

The privileges required to execute this statement are:

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