User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

To eliminate a SQL variable.

Syntax

     DROP VARIABLE identifier

Usage

Anywhere.

Permissions

None.

Side effects

None.

See also

• CREATE VARIABLE statement
• SET statement

Description

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).