DEALLOCATE

Function

Removes the prepared statements that were created earlier. If a prepared statement is not explicitly deleted, it is deleted at the end of the session.

Precautions

None

Syntax

1

DEALLOCATE [ PREPARE ] { name | ALL };

Parameter Description

• PREPARE

  This keyword is optional and is often ignored.

• name

  Specifies the name of the prepared statement to deallocate.

• ALL

  Deallocates all prepared statements.

Examples

None