Red Hat Docs  >  Manuals  >  Red Hat Database Manuals  > 

Red Hat Database: SQL Guide and Reference
PrevNext

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.

PrevHomeNext
REINDEXUpREVOKE