ASA SQL Reference
  SQL Statements

DEALLOCATE statement

Description 

Use this statement to free resources associated with a cursor.

Syntax 

DEALLOCATE [ CURSOR ] cursor-name

cursor-name : identifier

Usage 

Frees all memory associated with a cursor, including the data items, indicator variables, and the structure itself.

This option has no effect in Adaptive Server Anywhere. It is provided for compatibility with Adaptive Server Enterprise and Microsoft SQL Server. In Adaptive Server Enterprise, the CURSOR keyword is required. In Microsoft SQL Server, the keyword is not permitted. Adaptive Server Anywhere recognizes both forms.

Permissions 

None.

Side effects 

None.

See also 

DECLARE CURSOR statement [ESQL] [SP]

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

• Sybase    Supported by Adaptive Server Enterprise.