DEALLOCATE — deallocate a prepared statement
DEALLOCATE [ PREPARE ] { name | ALL }
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.
PREPAREThis key word is ignored.
nameThe name of the prepared statement to deallocate.
ALLDeallocate all prepared statements.
The SQL standard includes a DEALLOCATE statement, but it is only for use in embedded SQL.
If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.