DEALLOCATE

Deallocates a previously prepared statement. If a prepared statement is not explicitly deleted, it is deleted at the end of the session.

For details about prepared statements, see PREPARE.

None

     DEALLOCATE [ PREPARE ] { name | ALL };

**Table 1** DEALLOCATE parameters
Parameter	Description	Value Range
PREPARE	Creates a prepared statement. This keyword is optional and does not affect operations.	-
name	Specifies the name of the prepared statement to be deleted.	A string, which must comply with the naming rules of prepared statements.
ALL	Deallocates all prepared statements.	A string, which must comply with the prepared statement format.

None

Parent Topic: DCL Syntax

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.