DROP VARIABLE statement

Description

Eliminates a SQL variable.

Syntax

DROP VARIABLE identifier

Usage

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

None.

Standards

Permissions

None.

See also