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.


Syntax Syntax

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

SQL Tutorial, Domains


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.