Materialize Documentation
Join the Community github/materialize

DEALLOCATE

New in v0.9.7.

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

DEALLOCATE PREPARE name ALL
Field Use
PREPARE Disregarded.
name The name of the prepared statement to clear.
ALL Clear all prepared statements from this session.

Example

DEALLOCATE a;
Did this info help?
Yes No