Lu, Huayi a24ca60074 DWS DEVELOPER 811 version

Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>

2023-01-19 13:37:49 +00:00

3.1 KiB

Raw Permalink Blame History

DEALLOCATE

Function

DEALLOCATE deallocates a previously prepared statement. If you do not explicitly deallocate a prepared statement, it is deallocated when the session ends.

The PREPARE key word is always ignored.

Precautions

None

Syntax

1
DEALLOCATE [ PREPARE ] { name | ALL };

Parameter Description

name
Specifies the name of the prepared statement to deallocate.
ALL
Deallocates all prepared statements.

Examples