RESET

Use the RESET command to restore the value of a runtime parameter to its default value. The RESET command is an alternate form for the SET VARIABLE TO DEFAULT command.

Syntax

Syntax resetting a parameter:

RESET <variable>

Inputs

The RESET command takes the following input:

Table 1. RESET input
Input	Description
<variable>	The name of a runtime parameter.

Output

The RESET command has the following output:

Table 2. RESET output
Output	Description
`ERROR: "xy" Is not a valid option name.`	The system did not recognize the variable that you specify.

Privileges

You must be the admin user or must have the privilege that corresponds to the runtime parameter that is being reset.

Usage

The following provides sample usage.

To set DateStyle to its default value:
```
MYDB.SCH1(USER)=> RESET DateStyle;
```
To set Geqo to its default value:
```
MYDB.SCH1(USER)=> RESET geqo;
```