DROP DOMAIN
From InterBase
Go Up to Statement and Function Reference (Language Reference Guide)
Deletes a domain from a database. Available in gpre
, DSQL, and isql
.
DROP DOMAIN name;
Important:
In SQL statements passed to DSQL, omit the terminating semicolon. In embedded applications written in C and C++, and in
In SQL statements passed to DSQL, omit the terminating semicolon. In embedded applications written in C and C++, and in
isql
, the semicolon is a terminating symbol for the statement, so it must be included.Argument | Description |
---|---|
<name> |
Name of an existing domain |
Description: DROP DOMAIN
removes an existing domain definition from a database.
If a domain is currently used in any column definition in the database, the DROP
operation fails. To prevent failure, use ALTER TABLE
to delete the columns based on the domain before executing DROP DOMAIN
.
A domain may be dropped by its creator, the SYSDBA
, and any users with operating system root privileges.
Example: The following isql
statement deletes a domain:
DROP DOMAIN COUNTRYNAME;