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