Chapter 9 SQL Statements
513
DROP VARIABLE statement
Use this statement to eliminate a SQL variable.
DROP VARIABLE
identifier
None.
None.
"CREATE VARIABLE statement" on page 481
"SET statement" on page 605
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).
♦
SQL/92 Vendor extension.
♦
Sybase Not supported in Adaptive Server Enterprise.
Function
Syntax
Permissions
Side effects
See also
Description
Standards and
compatibility
To Next Page
Loading...