Categories:
Account & Session DDL

UNSET

Drops a session variable.

See also:
SHOW VARIABLES , SET

Syntax

UNSET <var>

UNSET ( <var> [ , <var> ... ] )

Parameters

var
Specifies the identifier for the variable to drop.

Usage Notes

  • The command supports dropping multiple variables in the same statement.
  • The command does not require a running warehouse to execute.

Examples

UNSET V1;

UNSET V2;

UNSET (V1, V2);