Dropping a Domain
From InterBase
Go Up to Working with Domains
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, delete the columns based on the domain with ALTER
TABLE
before executing DROP DOMAIN
.
A domain can be dropped by its creator, the SYSDBA, and any users with operating system root privileges.
The syntax of DROP DOMAIN
is:
DROP DOMAIN name;
The following statement deletes a domain:
DROP DOMAIN COUNTRYNAME;