---
name: "drop_language"
section: "7l"
platform: "linux"
package: "postgresql-client"
version: "7.2.1-2woody8"
release: "Debian 3.0 (Woody)"
platforms: ["linux"]
url: "https://new.carta.tech/drop_language/7l"
---

# drop\_language(7l)

remove a user-defined procedural language

## NAME

DROP LANGUAGE - remove a user-defined procedural language

## SYNOPSIS

```
DROP [ PROCEDURAL ] LANGUAGE name

```

### INPUTS

- *name*

  The name of an existing procedural language. For backward compatibility, the name may be enclosed by single quotes.

### OUTPUTS

- **DROP**

  This message is returned if the language is successfully dropped.

- **ERROR: Language "***name***" doesn't exist**

  This message occurs if a language called *name* is not found in the database.

## DESCRIPTION

**DROP PROCEDURAL LANGUAGE** will remove the definition of the previously registered procedural language called *name*.

### NOTES

The **DROP PROCEDURAL LANGUAGE** statement is a PostgreSQL language extension.

Refer to CREATE LANGUAGE \[**create\_language**(l)\] for information on how to create procedural languages.

No checks are made if functions or trigger procedures registered in this language still exist. To re-enable them without having to drop and recreate all the functions, the pg\_proc's prolang attribute of the functions must be adjusted to the new object ID of the recreated pg\_language entry for the PL.

## USAGE

This command removes the PL/Sample language:

```
DROP LANGUAGE plsample;

```

## COMPATIBILITY

### SQL92

There is no **DROP PROCEDURAL LANGUAGE** in  SQL92.