Home > APIs > YSQL > The SQL language > SQL statements >

DEALLOCATE

Synopsis

Use the DEALLOCATE statement to deallocate a previously prepared SQL statement.

deallocate ::= DEALLOCATE [ PREPARE ] { name | ALL }

Specify the name of the prepared statement to deallocate.

Deallocate all prepared statements.

Prepare and deallocate an insert statement.

yugabyte=# CREATE TABLE sample(k1 int, k2 int, v1 int, v2 text, PRIMARY KEY (k1, k2));

yugabyte=# PREPARE ins (bigint, double precision, int, text) AS 
               INSERT INTO sample(k1, k2, v1, v2) VALUES ($1, $2, $3, $4);

yugabyte=# DEALLOCATE ins;