---
schema_version: "1"
id: 7cd5ae72d2bceb15953ac8848030a986d2ad3a002bec2ac9cc6f9a4375371f76
title: DEALLOCATE
collection: developer
version: current
locale: en-us
portal_url: https://docs.salesforce.com/developer/current/en-us/data-cloud/data-cloud-query-guide/references/data-cloud-sql-reference/tableau-sql-commands/deallocate.md
canonical_url: https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/deallocate.html
source_site: developer.salesforce.com
content_type: documentation
content_hash: b27766a8f44553288422ce64fe1f21b08f7eb51fadc706039c685e35277b1036
products:
  - Data 360 Query Guide
  - Data 360 Developer Documentation
---
# DEALLOCATE

**Applies to:** ❌ Data 360 SQL ✅ Tableau Hyper API

Deallocate a prepared statement.

## Syntax

```sql
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](https://developer.salesforce.com/docs/data/data-cloud-query-guide/references/dc-sql-reference/prepare.md).

## Parameters

- `PREPARE`

  - : This optional key word is ignored and has no semantical meaning.

- `<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.