---
name: "deallocate"
section: "7"
platform: "linux"
package: "postgresql"
version: "7.4.7-6sarge6"
release: "Debian 3.1 (Sarge)"
platforms: ["linux"]
url: "https://new.carta.tech/deallocate"
---

# deallocate(7)

deallocate a prepared statement

## NAME

DEALLOCATE - deallocate a prepared statement

## SYNOPSIS

```
DEALLOCATE [ PREPARE ] plan_name

```

## 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**(7)](/prepare/7.md)\].

## PARAMETERS

- **PREPARE**

  This key word is ignored.

- *plan\_name*

  The name of the prepared statement to deallocate.

## COMPATIBILITY

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