Skip to content
Developer Edition runs on one host and does not require a product license file. Need multi-host deployment or performance testing at scale? Explore Enterprise Edition

SESSION UNSET command

The SESSION UNSET command unsets the value of a configuration option set using SESSION SET or SESSION RESET for the current session. The configuration options unset by SESSION UNSET are not displayed by SHOW SESSION CONFIGS.

  • To view the session configuration options set in the current session, see SHOW SESSION CONFIGS.
  • To learn how to set session configuration options, see SESSION SET.

Syntax

session_unset_command
SESSION UNSET config_option 

session_unset_command ::=
    'SESSION' 'UNSET' config_option

Parameters

config_option

The name of the configuration option to unset in the current session (must be set via SESSION SET or SESSION RESET).

Examples

SESSION SET timezone = "Asia/Shanghai" // Set the timezone for the current session to Asia/Shanghai.
SESSION UNSET timezone // Unset the timezone setting in the current session.