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