Seth Woolley's Man Viewer

deallocate(7) - DEALLOCATE - deallocate a prepared statement - man 7 deallocate

([section] manual, -k keyword, -K [section] search, -f whatis)
man plain no title

DEALLOCATE(7)                    SQL Commands                    DEALLOCATE(7)



NAME
       DEALLOCATE - deallocate a prepared statement


SYNOPSIS
       DEALLOCATE [ PREPARE ] plan_name


DESCRIPTION
       DEALLOCATE  is  used to deallocate a previously prepared SQL statement.
       If you do not explicitly deallocate a prepared statement, it is deallo-
       cated when the session ends.

       For  more information on prepared statements, see PREPARE [prepare(7)].

PARAMETERS
       PREPARE
              This key word is ignored.

       plan_name
              The name of the prepared statement to deallocate.

COMPATIBILITY
       The SQL standard includes a DEALLOCATE statement, but it  is  only  for
       use in(1,8) embedded SQL.



SQL - Language Statements         2003-11-02                     DEALLOCATE(7)

References for this manual (incoming links)