PostgreSQL 7.3.4 Documentation
Prev |  | Next

# DROP DOMAIN

## Name

DROP DOMAIN -- remove a user-defined domain

## Synopsis

    DROP DOMAIN domainname [, ...]  [ CASCADE | RESTRICT ]

### Inputs

domainname

  The name (optionally schema-qualified) of an existing domain.

CASCADE

  Automatically drop objects that depend on the domain (such as table columns).

RESTRICT

  Refuse to drop the domain if there are any dependent objects. This is the default.

### Outputs

`DROP DOMAIN`

  The message returned if the command is successful.

`ERROR: RemoveDomain: type 'domainname' does not exist`

  This message occurs if the specified domain (or type) is not found.

## Description

`DROP DOMAIN` will remove a user domain from the system catalogs.

Only the owner of a domain can remove it.

## Examples

To remove the `box` domain:

    DROP DOMAIN box;

## Compatibility

### SQL92

## See Also

CREATE DOMAIN

Prev | Home | Next
DROP DATABASE | Up | DROP FUNCTION