Dropping a Domain

From InterBase
Jump to: navigation, search

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;

Advance To: