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;
–>
Related articles
Feedback
https://aka.ms/ContentUserFeedback.
Kommer snart: I hele 2024 udfaser vi GitHub-problemer som feedbackmekanisme for indhold og erstatter det med et nyt feedbacksystem. Du kan få flere oplysninger under:Indsend og få vist feedback om