DEALLOCATE DESCRIPTOR statement [ESQL]

Description

Frees memory associated with a SQL descriptor area.

Syntax

DEALLOCATE DESCRIPTOR descriptor-name:
string

Examples

Example 1

See ALLOCATE DESCRIPTOR statement [ESQL].

Usage

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

Side effects

None.

Standards

SQL92 Entry-level feature.

Sybase Supported by Open Client/Open Server.

Permissions

None.

See also

SET DESCRIPTOR statement [ESQL]

“The Embedded SQL Interface” in Adaptive Server Anywhere Programming Interface Guide