DEALLOCATE
Function
DEALLOCATE deallocates a previously prepared statement. If you do not explicitly deallocate a prepared statement, it is deallocated when the session ends.
The PREPARE key word is always ignored.
Precautions
None
Syntax
1 | DEALLOCATE [ PREPARE ] { name | ALL };
|
Parameter Description
- name
Specifies the name of the prepared statement to deallocate.
- ALL
Deallocates all prepared statements.
Examples
None
Parent topic: DCL Syntax
Last Article: ANALYZE | ANALYSE
Next Article: DO
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.