deallocate.md 690 B
title: "DEALLOCATE"
description: "DEALLOCATE clears a prepared statement."
menu:
main:
parent: "commands"
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
{{< diagram "deallocate.svg" >}}
| Field | Use |
|---|---|
| PREPARE | Disregarded. |
| name | The name of the prepared statement to clear. |
| ALL | Clear all prepared statements from this session. |
Example
DEALLOCATE a;