ContextQMD
Back to Materialize

RESET

doc/user/content/sql/reset.md

123692 B
Original Source

RESET restores the value of a configuration parameter to its default value. This command is an alternative spelling for SET...TO DEFAULT.

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

Syntax

mzsql
RESET <parameter_name>;
Syntax elementDescription
<parameter_name>The configuration parameter's name.

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

Examples

Reset search path

mzsql
SHOW search_path;

 search_path
-------------
 qck

RESET search_path;

SHOW search_path;

 search_path
-------------
 public