RESET
Applies to: Databricks SQL Databricks Runtime
Resets Databricks SQL parameters at the session level to the global default values if they were changed using the SET command. When using Databricks Runtime, parameters are known as SQL Conf properties.
Syntax
RESET [ parameter_key ]
Parameters
parameter_key
Applies to: Databricks SQL
Optionally resets the value of the specified to the global default value. If you do not name a parameter all parameters are reset.
(none)
Applies to: Databricks Runtime
Reset any runtime configurations specific to the current session which were set via the SET command to your default values.
Examples
-- Reset all parameters.
> RESET;
-- I, Databricks SQL if the default value of ansi_mode is true and you ran SET ansi_mode=false, the example below will restore it to 'true'.
> RESET ansi_mode;