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.
The message returned if the command is successful.
This message occurs if the specified domain (or type) is not found.
DROP DOMAIN will remove a user domain from the system catalogs.
Only the owner of a domain can remove it.
To remove the box domain:
DROP DOMAIN box;