Background documentationDROP DOMAIN Statement (drop_domain_statement) Locate this document in the navigation structure

 

The DROP DOMAIN statement (drop_domain_statement) deletes the definition of a domain.

Structure

Syntax Syntax

  1. <drop_domain_statement> ::=
      DROP DOMAIN <domain_name>
End of the code.
Examples

SQL Tutorial, Domains

Explanation

The domain name must identify an existing domain. The domain must be contained in the current database user’s schema.

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.