Purpose
Releases a previously prepared statement.
Invocation
Executable.
Stored procedures.
Syntax
DEALLOCATE PREPARE statement_name ;
- statement_name
- The same identifier as statement name in a PREPARE statement.
ANSI Compliance
ANSI/ISO SQL:2011-compliant.
Authorization
None.
Example: Using DEALLOCATE PREPARE
DECLARE sql_stmt1 VARCHAR(100); DECLARE item INTEGER; DECLARE price DECIMAL(8,2); SET sql_stmt1 = 'INSERT INTO T1 (?,?);'; PREPARE stmt1 FROM sql_stmt1; SET item = 1052; SET price = 3.95; EXECUTE stmt1 USING item, price; SET item = 3967; SET price = 10.85; EXECUTE stmt1 USING item, price; DEALLOCATE PREPARE stmt1;