.\\" auto-generated by docbook2man-spec $Revision: 1.25 $
.TH "DEALLOCATE" "7" "2002-11-22" "SQL - Language Statements" "SQL Commands"
.SH NAME
DEALLOCATE \- remove a prepared query
.SH SYNOPSIS
.sp
.nf
   DEALLOCATE [ PREPARE ] \fIplan_name\fR
  
.sp
.fi
.SS "INPUTS"
.PP
.TP
\fBPREPARE\fR
This keyword is ignored.
.TP
\fB\fIplan_name\fB\fR
The name of the prepared query to remove.
.PP
.SS "OUTPUTS"
.PP
.TP
\fBDEALLOCATE\fR
The prepared query was removed successfully.
.PP
.SH "DESCRIPTION"
.PP
\fBDEALLOCATE\fR is used to remove a previously
prepared query. If you do not explicitly
\fBDEALLOCATE\fR a prepared query, it is removed when
the session ends.
.PP
For more information on prepared queries, see PREPARE [\fBprepare\fR(7)].
.SH "COMPATIBILITY"
.SS "SQL92"
.PP
SQL92 includes a \fBDEALLOCATE\fR statement, but it is
only for use in embedded SQL clients.