Skip to main content

DEALLOCATE

Deallocates a prepared statement.

Syntax​

DEALLOCATE [PREPARE] { <name> | ALL }

Description​

DEALLOCATE is used to deallocate a prepared statement. If you do not run DEALLOCATE to explicitly deallocate the prepared statement, it will automatically end when the session ends.

Parameters​

  • PREPARE

    An optional keyword that has no effect.

  • <name>

    The name of the prepared statement to deallocate.

  • ALL

    If you want to deallocate all prepared statements, specify ALL instead of <name>.

Examples​

Deallocate prepared statement add_films:

DEALLOCATE add_films;

SQL standard compatibility​

DEALLOCATE in standard SQL can be used only in embedded SQL.