1DEALLOCATE() SQL Commands DEALLOCATE()
2
3
4
6 DEALLOCATE - deallocate a prepared statement
7
8
10 DEALLOCATE [ PREPARE ] name
11
12
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
21 PREPARE
22 This key word is ignored.
23
24 name The name of the prepared statement to deallocate.
25
27 The SQL standard includes a DEALLOCATE statement, but it is only for
28 use in embedded SQL.
29
31 EXECUTE [execute(7)], PREPARE [prepare(l)]
32
33
34
35SQL - Language Statements 2008-06-08 DEALLOCATE()