DEALLOCATE
Deallocates a prepared statement.
Synopsis
DEALLOCATE [PREPARE] <name>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
| Parameter | Description |
|---|---|
PREPARE |
Optional keyword which is ignored |
name |
Name of the prepared statement to deallocate |
Examples
Deallocate the previously prepared statement named insert_names:
DEALLOCATE insert_names;Compatibility
The SQL standard includes a DEALLOCATE statement, but it is only for use in embedded SQL.