NAME

DROP DOMAIN - 刪除一個(gè)用戶定義的域

SYNOPSIS

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

DESCRIPTION 描述

DROP DOMAIN 將從系統(tǒng)表中刪除一個(gè)用戶域。 只有域的所有者才能刪除它。  

PARAMETERS 參數(shù)

name

 一個(gè)現(xiàn)有的域（可以有模式修飾）。

CASCADE

 自動(dòng)刪除倚賴域的對(duì)象。（比如，表字段）。

RESTRICT

 如果有任何依賴對(duì)象存在，則拒絕刪除此域。這個(gè)是缺省。

EXAMPLES 例子

 刪除 box 域∶

DROP DOMAIN box;

COMPATIBILITY 兼容性

 這條命令遵循 SQL 標(biāo)準(zhǔn)。  

SEE ALSO 參見(jiàn)

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)]