DEALLOCATE
This page documents a preview version.
v2.23 Preview
Preview includes features under active development and is for development and testing only.
For production, use the latest stable version (v2024.1).
For production, use the latest stable version (v2024.1).
Synopsis
Use the DEALLOCATE
statement to deallocate a previously prepared SQL statement.
Syntax
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;