RESET

Name

RESET -- Restores run-time parameters to default values

Synopsis

RESET variable
  

Inputs

variable

The name of a run-time parameter. See SELECT for a list.

Description

RESET restores run-time parameters to their default values. RESET is an alternate form for
SET variable TO DEFAULT
   

Outputs

RESET VARIABLE

This message is returned if the variable is successfully reset.

ERROR: Option 'VARIABLE' is not recognized

This message is returned if VARIABLE is an invalid argument.

Examples

Set DateStyle to its default value:
RESET DateStyle;

Set Geqo to its default value:
   
RESET GEQO;

Compatibility

There is no RESET statement in SQL92.