1DEALLOCATE(7)                    SQL Commands                    DEALLOCATE(7)
2
3
4

NAME

6       DEALLOCATE - deallocate a prepared statement
7
8

SYNOPSIS

10       DEALLOCATE [ PREPARE ] { name | ALL }
11
12

DESCRIPTION

14       DEALLOCATE  is  used to deallocate a previously prepared SQL statement.
15       If you do not explicitly deallocate a prepared statement, it is deallo‐
16       cated when the session ends.
17
18       For more information on prepared statements, see PREPARE [prepare(7)].
19

PARAMETERS

21       PREPARE
22              This key word is ignored.
23
24       name   The name of the prepared statement to deallocate.
25
26       ALL    Deallocate all prepared statements.
27

COMPATIBILITY

29       The  SQL  standard  includes a DEALLOCATE statement, but it is only for
30       use in embedded SQL.
31

SEE ALSO

33       EXECUTE [execute(7)], PREPARE [prepare(7)]
34
35
36
37SQL - Language Statements         2011-09-22                     DEALLOCATE(7)
Impressum