drop_domain.7

来自「PostgreSQL 8.2中增加了很多企业用户所需要的功能和性能上的提高,其开」· 7 代码 · 共 47 行

.\\" auto-generated by docbook2man-spec $Revision: 1.1.1.1 $
.TH "DROP DOMAIN" "" "2008-01-03" "SQL - Language Statements" "SQL Commands"
.SH NAME
DROP DOMAIN \- remove a domain

.SH SYNOPSIS
.sp
.nf
DROP DOMAIN [IF EXISTS ] \fIname\fR [, ...]  [ CASCADE | RESTRICT ]
.sp
.fi
.SH "DESCRIPTION"
.PP
\fBDROP DOMAIN\fR will remove a domain. Only the
owner of a domain can remove it.
.SH "PARAMETERS"
.TP
\fBIF EXISTS\fR
Do not throw an error if the domain does not exist. A notice is issued 
in this case.
.TP
\fB\fIname\fB\fR
The name (optionally schema-qualified) of an existing domain.
.TP
\fBCASCADE\fR
Automatically drop objects that depend on the domain (such as
table columns).
.TP
\fBRESTRICT\fR
Refuse to drop the domain if any objects depend on it. This is
the default.
.SH "EXAMPLES"
.PP
To remove the domain \fBbox\fR:
.sp
.nf
DROP DOMAIN box;
.sp
.fi
.SH "COMPATIBILITY"
.PP
This command conforms to the SQL standard, except for the
IF EXISTS option, which is a PostgreSQL 
extension.
.SH "SEE ALSO"
CREATE DOMAIN [\fBcreate_domain\fR(7)], ALTER DOMAIN [\fBalter_domain\fR(l)]