UNSETΒΆ

Drops a session variable.

See also:

SHOW VARIABLES , SET

SyntaxΒΆ

UNSET <var>

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

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