DROP DOMAIN
Removes
a domain from the database.
SYNTAX
| domain_name |
Name
of the domain you want to remove from the database. |
DESCRIPTION
The DROP
DOMAIN command removes an existing domain from the database. To execute
the DROP DOMAIN command, you must be the domain owner, or have DBA or
SYSADM security privileges.
A domain
is a user-defined data type that brings together a data type, a default
value, and a value constraint. You can use a domain in the column definition
of CREATE TABLE or ALTER TABLE ADD COLUMN statements in place of a data
type to define the set of valid values that can be entered into the column.
You cannot
drop a domain if there are existing columns in a table that were defined
using the domain. To drop a domain that is referenced by existing columns,
you must first drop all columns that reference the domain. You can do
this by dropping the entire table and then recreating the table without
the domain, or by dropping a single column using the ALTER TABLE DROP
COLUMN command.
EXAMPLE
The following
example removes the domain named ValidDate from the database.
RELATED COMMANDS
<
DROP COMMAND | Contents
| DROP GROUP >
|
