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

# drop\_language(7)

remove a procedural language

## NAME

DROP LANGUAGE - remove a procedural language

## SYNOPSIS

```
DROP [ PROCEDURAL ] LANGUAGE name [ CASCADE | RESTRICT ]

```

## DESCRIPTION

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

## PARAMETERS

- *name*

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

- **CASCADE**

  Automatically drop objects that depend on the language (such as functions in the language).

- **RESTRICT**

  Refuse to drop the language if any objects depend on it. This is the default.

## EXAMPLES

This command removes the procedural language plsample:

```
DROP LANGUAGE plsample;

```

## COMPATIBILITY

There is no **DROP LANGUAGE** statement in the SQL standard.

## SEE ALSO

ALTER LANGUAGE \[[**alter\_language**(7)](/alter_language/7.md)\], CREATE LANGUAGE \[**create\_language**(l)\], [**droplang**(1)](/droplang/1.md)