DROP VARIABLE statement

Description

Eliminates a SQL variable.

Syntax

DROP VARIABLE identifier

Usage

DROP VARIABLE eliminates a SQL variable previously created using CREATE VARIABLE. Variables are automatically eliminated when the database connection is released. However, variables are often used for large objects. Thus, eliminating them after use might free up significant resources (primarily disk space).


Side effects

None.

Standards

Permissions

None

See also

CREATE VARIABLE statement

SET statement