A newer version of this documentation is available. Click here to view the most up-to-date release of the Greenplum 4.x documentation.
Deallocates a prepared statement.
DEALLOCATE [PREPARE] name
DEALLOCATE is used to deallocate a previously prepared SQL statement. If you do not explicitly deallocate a prepared statement, it is deallocated when the session ends.
For more information on prepared statements, see PREPARE.
- Optional key word which is ignored.
- The name of the prepared statement to deallocate.
Deallocated the previously prepared statement named insert_names:
The SQL standard includes a DEALLOCATE statement, but it is only for use in embedded SQL.