Help Center/ Data Warehouse Service / SQL Syntax Reference (9.1.0.x)/ DCL Syntax/ DEALLOCATE
Updated on 2025-09-18 GMT+08:00
View PDF

DEALLOCATE

Function

Deallocates a previously prepared statement. 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

Table 1 DEALLOCATE parameters

Parameter

Description

Value Range

PREPARE

Creates a prepared statement. This keyword is optional and does not affect operations.

-

name

Specifies the name of the prepared statement to be deleted.

A string, which must comply with the naming rules of prepared statements.

ALL

Deallocates all prepared statements.

A string, which must comply with the prepared statement format.

Examples

None

Parent Topic: DCL Syntax