SQL COMMANDS / CURSORS & PREPARED STATEMENTS

DEALLOCATE

deallocate a prepared statement

Syntax

DEALLOCATE [ PREPARE ] { name | ALL }

Syntax diagrams

Read left to right. Branches are choices, bypasses are optional, loops repeat. Select an underlined parameter to open its rule.

Description

DEALLOCATE is used to deallocate a previously prepared SQL statement. If you do not explicitly deallocate a prepared statement, it is deallocated when the session ends.

For more information on prepared statements, see PREPARE.

Parameters

PREPARE: This key word is ignored.
name: The name of the prepared statement to deallocate.
ALL: Deallocate all prepared statements.

Compatibility

The SQL standard includes a DEALLOCATE statement, but it is only for use in embedded SQL.

Related entries

Definition snapshot: 2026-09-14T13:14:25.700916+00:00@99e6866c · English manual source