ContextQMD
Back to Materialize

DEALLOCATE

doc/user/content/sql/deallocate.md

123576 B
Original Source

DEALLOCATE clears prepared statements that have been created during the current session. Even without an explicit DEALLOCATE command, all prepared statements will be cleared at the end of a session.

Syntax

mzsql
DEALLOCATE <name>|ALL ;
Syntax elementDescription
<name>The name of the prepared statement to clear.
ALLClear all prepared statements from this session.

Example

mzsql
DEALLOCATE a;