RESET
Restores the value of a configuration parameter to its default value.
You can reset either a single specified parameter or all parameters at once. To set a parameter to a specific value, use the SET command. To display the current value of a parameter, use the SHOW command.
Syntax
RESET { parameter_name | ALL }
The following statement sets the value of a session context variable to NULL.
RESET { variable_name | ALL }
Parameters
- parameter_name
-
Name of the parameter to reset. See Modifying the server configuration for more documentation about parameters.
- ALL
-
Resets all runtime parameters, including all the session context variables.
- variable
-
The name of the variable to reset. If the value to RESET is a session context variable, Amazon Redshift sets it to NULL.
Examples
The following example resets the query_group parameter to its default
value:
reset query_group;
The following example resets all runtime parameters to their default values.
reset all;
The following example resets the context variable.
RESET app_context.user_id;