Reference Manual
   CHAPTER 9. SQL Statements     

DROP VARIABLE statement

Function 

To eliminate a SQL variable.

Syntax 

DROP VARIABLE identifier

Permissions 

None.

Side effects 

None.

See also 

CREATE VARIABLE statement

SET statement

Description 

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. Because, variables are often used for large objects, eliminating them after use may free up significant resources (primarily disk space).

Standards and compatibility 

• SQL/92     Vendor extension.

• Sybase     Not supported in Adaptive Server Enterprise.