Help Center > > Developer Guide> SQL Reference> SQL Syntax> DEALLOCATE

DEALLOCATE

Updated at: Mar 13, 2020 GMT+08:00

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

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel