reference/sql/RESET.html.md.erb

---
title: RESET
---

Restores the value of a system configuration parameter to the default value.

## <a id="topic1__section2"></a>Synopsis

``` pre
RESET <configuration_parameter>

RESET ALL
```

## <a id="topic1__section3"></a>Description

`RESET` restores system configuration parameters to their default values. `RESET` is an alternative spelling for `SET                   configuration_parameter TO DEFAULT`.

The default value is defined as the value that the parameter would have had, had no `SET` ever been issued for it in the current session. The actual source of this value might be a compiled-in default, the master `hawq-site.xml` configuration file, command-line options, or per-database or per-user default settings.

See [Server Configuration Parameter Reference](../HAWQSiteConfig.html) for more information.

## <a id="topic1__section4"></a>Parameters

<dt> \<configuration\_parameter\>   </dt>
<dd>The name of a system configuration parameter. See [Server Configuration Parameter Reference](../HAWQSiteConfig.html) for a list of configuration parameters.</dd>

<dt>ALL  </dt>
<dd>Resets all settable configuration parameters to their default values.</dd>

## <a id="topic1__section5"></a>Examples

Set the `hawq_rm_stmt_vseg_memory` configuration parameter to its default value:

``` sql
RESET hawq_rm_stmt_vseg_memory; 
```

## <a id="topic1__section6"></a>Compatibility

`RESET` is a HAWQ extension.

## <a id="topic1__section7"></a>See Also

[SET](SET.html)