---
title: "DEALLOCATE DESCRIPTOR"
id: ecpg-sql-deallocate-descriptor
pg_version: "20devel"
---

<a id="ecpg-sql-deallocate-descriptor"></a>

# DEALLOCATE DESCRIPTOR — deallocate an SQL descriptor area

## Synopsis

```
DEALLOCATE DESCRIPTOR name
```

<a id="id-1.7.5.20.5.3"></a>

## Description

`DEALLOCATE DESCRIPTOR` deallocates a named SQL descriptor area. 

<a id="id-1.7.5.20.5.4"></a>

## Parameters

<a id="ecpg-sql-deallocate-descriptor-name"></a>

**`name`**

 The name of the descriptor which is going to be deallocated. It is case sensitive. This can be an SQL identifier or a host variable. <a id="id-1.7.5.20.5.5"></a>

## Examples


EXEC SQL DEALLOCATE DESCRIPTOR mydesc;
<a id="id-1.7.5.20.5.6"></a>

## Compatibility

`DEALLOCATE DESCRIPTOR` is specified in the SQL standard. 

<a id="id-1.7.5.20.5.7"></a>

## See Also

[ALLOCATE DESCRIPTOR](ecpg-sql-allocate-descriptor.md), [GET DESCRIPTOR](ecpg-sql-get-descriptor.md), [SET DESCRIPTOR](ecpg-sql-set-descriptor.md)