DEALLOCATE

This page documents the preview version (v2.21). Preview includes features under active development and is for development and testing only. For production, use the stable version (v2024.1). To learn more, see Versioning.

Synopsis

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

Syntax

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

deallocate

DEALLOCATEPREPAREnameALL

Semantics

name

Specify the name of the prepared statement to deallocate.

ALL

Deallocate all prepared statements.

Examples

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;

See also