---
name: "DEALLOCATE"
section: "7"
platform: "linux"
package: "postgresql"
version: "18.6-4"
release: "Arch Linux 2026-11-01"
platforms: ["linux"]
url: "https://new.carta.tech/DEALLOCATE"
---

# DEALLOCATE(7)

deallocate a prepared statement

## NAME

DEALLOCATE - deallocate a prepared statement

## SYNOPSIS

```
DEALLOCATE [ PREPARE ] { name | ALL }
```

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

## PARAMETERS

PREPARE

This key word is ignored.

*name*

The name of the prepared statement to deallocate.

ALL

Deallocate all prepared statements.

## COMPATIBILITY

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

## SEE ALSO

[**EXECUTE**(7)](/EXECUTE/7.md), [**PREPARE**(7)](/PREPARE/7.md)