DEALLOCATE PREPARE

2023-10-31 11:17:11  Updated

Purpose

You can use this statement to drop a prepared statement produced with PREPARE.

Syntax

{DEALLOCATE | DROP} PREPARE stmt_name

Parameters

Parameter Description
stmt_name The name of the prepared statement.

Examples

Drop a prepared statement.

obclient> PREPARE stmt1 FROM 'PURGE RECYCLEBIN';
Query OK, 0 rows affected

obclient> DROP PREPARE stmt1;
Query OK, 0 rows affected

Contact Us