reference/sql/DEALLOCATE.html.md.erb

---
title: DEALLOCATE
---

Deallocates a prepared statement.

## <a id="topic1__section2"></a>Synopsis

``` pre
DEALLOCATE [PREPARE] <name>
         
```

## <a id="topic1__section3"></a>Description

`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](PREPARE.html).

## <a id="topic1__section4"></a>Parameters

<dt>PREPARE  </dt>
<dd>Optional key word which is ignored.</dd>

<dt>\<name\>  </dt>
<dd>The name of the prepared statement to deallocate.</dd>

## <a id="topic1__section5"></a>Examples

Deallocated the previously prepared statement named `insert_names`:

``` pre
DEALLOCATE insert_names;
```

## <a id="topic1__section6"></a>Compatibility

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

## <a id="topic1__section7"></a>See Also

[EXECUTE](EXECUTE.html), [PREPARE](PREPARE.html)