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
obclient> DROP PREPARE stmt1;
Query OK, 0 rows affected