Provided by: postgresql-client-8.4_8.4.11-1_i386 bug

NAME

       DROP DOMAIN - remove a domain

SYNOPSIS

       DROP DOMAIN [ IF EXISTS ] name [, ...] [ CASCADE | RESTRICT ]

DESCRIPTION

       DROP DOMAIN removes a domain. Only the owner of a domain can remove it.

PARAMETERS

       IF EXISTS
              Do  not throw an error if the domain does not exist. A notice is
              issued in this case.

       name   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 any objects depend on it. This is
              the default.

EXAMPLES

       To remove the domain box:

       DROP DOMAIN box;

COMPATIBILITY

       This command conforms to the SQL standard, except  for  the  IF  EXISTS
       option, which is a PostgreSQL extension.

SEE ALSO

       CREATE DOMAIN [create_domain(7)], ALTER DOMAIN [alter_domain(7)]