Purpose
This statement is used to deallocate a prepared statement.
Syntax
{DEALLOCATE | DROP} PREPARE stmt_name
Parameters
| Parameter | Description |
|---|---|
| stmt_name | The name of the prepared statement. |
Examples
Deallocate the prepared statement.
obclient> PREPARE stmt1 FROM 'PURGE RECYCLEBIN';
obclient> DROP PREPARE stmt1;