RESET (Databricks SQL)

Resets Databricks SQL parameters at the session level to the global default values if they were changed using the SET command.

Syntax

RESET [ parameter_key ]

Parameters

  • parameter_key

    Optionally resets the value of the specified to the global default value. If you do not name a parameter all parameters are reset.

Examples

-- Reset all parameters.
> RESET;

-- 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;

–>