Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-3.x)/ SQL Reference/ SQL Syntax/ DEALLOCATE
Updated on 2025-08-19 GMT+08:00
View PDF

DEALLOCATE

Description

DEALLOCATE deallocates prepared statements.

Precautions

  • If you do not explicitly deallocate a prepared statement, it is deallocated when the session ends.
  • The PREPARE keyword in the syntax is always ignored.

Syntax

1
 
DEALLOCATE [ PREPARE ] { name | ALL };

Parameters

  • name

    Specifies the name of the prepared statement to be deallocated.

  • ALL

    Deallocates all prepared statements.

Examples

None

Parent topic: SQL Syntax