Dropping a Domain - Firebird

DROP DOMAIN removes an existing domain definition from a database, provided the domain is not currently used for any column definition in the database.

To avoid exceptions, use ALTER TABLE to drop any table columns using the domain before executing DROP DOMAIN. The best way to do this in a single task is with a DDL script. Refer to the section “Schema Scripts” in the next chapter for instructions.

A domain can be dropped by its creator, the SYSDBA user, or (on Linux/UNIX) any user with operating system root privileges.

Here’s the syntax:

DROP DOMAIN name;

The following statement deletes an unwanted domain:

DROP DOMAIN rather_silly;

All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Firebird Topics