Help Center/ GaussDB(DWS)/ SQL Syntax Reference/ SQL Syntax Reference (8.1.3.x)/ DCL Syntax/ DEALLOCATE
Updated on 2024-09-03 GMT+08:00
View PDF
Share

DEALLOCATE

Function

Removes the prepared statements that were created earlier. If a prepared statement is not explicitly deleted, it is deleted at the end of the session.

For details about prepared statements, see PREPARE.

Precautions

None

Syntax

1
 
DEALLOCATE [ PREPARE ] { name | ALL };

Parameter Description

  • PREPARE

    This keyword is optional and is often ignored.

  • name

    Specifies the name of the prepared statement to deallocate.

  • ALL

    Deallocates all prepared statements.

Examples

None

Parent topic: DCL Syntax