DEALLOCATE
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 <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;