ASA SQL Reference
  SQL Statements

DROP VARIABLE statement

Description 

Use this statement to eliminate a SQL variable.

Syntax 

DROP VARIABLE identifier

Usage 

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

Permissions 

None.

Side effects 

None.

See also 

CREATE VARIABLE statement

SET statement

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Not supported in Adaptive Server Enterprise.