DROP DOMAIN statement 

A DROP DOMAIN statement drops the definition of a domain.

Syntax

<drop domain statement> ::= DROP DOMAIN <domain name>

domain name

Explanation

The domain name must identify an existing domain. The current user must be owner of the domain.

The metadata of the domain is dropped from the catalog. Dropping a domain has no effect on tables in which this domain was used to define columns.