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