DEALLOCATE

DEALLOCATE

prepared statements

removing

DEALLOCATE

7

SQL - Language Statements

DEALLOCATE

deallocate a prepared statement

DEALLOCATE [ PREPARE ] {

name

| ALL }

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

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.

See Also#