NAME
DROP DOMAIN - 删除一个用户定义的域
SYNOPSIS
DROP DOMAIN name [, ...] [ CASCADE | RESTRICT ]
DESCRIPTION 描述
DROP DOMAIN 将从系统表中删除一个用户域。 只有域的所有者才能删除它。
PARAMETERS 参数
- name
一个现有的域（可以有模式修饰）。- CASCADE
自动删除倚赖域的对象。（比如，表字段）。- RESTRICT
如果有任何依赖对象存在，则拒绝删除此域。这个是缺省。
EXAMPLES 例子
删除 box 域∶
DROP DOMAIN box;
COMPATIBILITY 兼容性
这条命令遵循 SQL 标准。
SEE ALSO 参见
CREATE DOMAIN [create_domain(7)]
#p#
NAME
DROP DOMAIN - remove a domain
SYNOPSIS
DROP DOMAIN name [, ...] [ CASCADE | RESTRICT ]
DESCRIPTION
DROP DOMAIN will remove a domain. Only the owner of a domain can remove it.
PARAMETERS
- 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.
SEE ALSO
CREATE DOMAIN [create_domain(7)]
