Purpose
You can use this statement to drop a PREPARE statement.
Syntax
{DEALLOCATE DROP} PREPARE stmt_name
Parameters
| Parameter | Description |
|---|---|
| stmt_name | The name of the PREPARE statement. |
Examples
Drop a PREPARE statement.
obclient> PREPARE stmt1 FROM 'PURGE RECYCLEBIN';
Query OK, 0 rows affected (0.00 sec)
obclient> DROP PREPARE stmt1;
Query OK, 0 rows affected (0.00 sec)