DROP DOMAIN SQL - Language Statements DROP DOMAIN remove a user-defined domain 1999-07-20 DROP DOMAIN domainname [, ...] 2002-02-24 domainname The name of an existing domain. 2002-02-24 DROP 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. 2002-02-24 DROP DOMAIN will remove a user domain from the system catalogs. Only the owner of a domain can remove it. It is the user's responsibility to remove any operators, functions, aggregates, access methods, and tables that use a deleted domain. To remove the box domain: DROP DOMAIN box RESTRICT; A DROP DOMAIN statement exists in SQL99. As with most other drop commands, DROP DOMAIN in SQL99 requires a drop behavior clause to select between dropping all dependent objects or refusing to drop if dependent objects exist: DROP DOMAIN name { CASCADE | RESTRICT } PostgreSQL enforces the existance of RESTRICT or CASCADE but ignores their enforcement against the system tables.