DEALLOCATE
View as MarkdownDEALLOCATE 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 <name>|ALL ;
| Syntax element | Description |
|---|---|
<name> |
The name of the prepared statement to clear. |
| ALL | Clear all prepared statements from this session. |
Example
DEALLOCATE a;