markdown/reference/sql/RESET.html.md.erb

---
title: RESET
---

<!--
Licensed to the Apache Software Foundation (ASF) under one
or more contributor license agreements.  See the NOTICE file
distributed with this work for additional information
regarding copyright ownership.  The ASF licenses this file
to you under the Apache License, Version 2.0 (the
"License"); you may not use this file except in compliance
with the License.  You may obtain a copy of the License at

  http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing,
software distributed under the License is distributed on an
"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
KIND, either express or implied.  See the License for the
specific language governing permissions and limitations
under the License.
-->

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)