DROP DOMAIN domainname [, ...] [ CASCADE | RESTRICT ]
The name (optionally schema-qualified) of an existing domain.
Automatically drop objects that depend on the domain (such as table columns).
Refuse to drop the domain if there are any dependent objects. This is the default.
DROP DOMAIN will remove a user domain from the system catalogs.
Only the owner of a domain can remove it.