DROP DOMAIN
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
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;