drop domain

Drop a domain definition

Syntax

drop_domain:
          DROP DOMAIN [database_name.]domain_name

Description

The DROP DOMAIN statement deletes the domain definition from the database definition. If specified, the database_name, must match that associated with the most recently issued CREATE/ALTER SCHEMA statement. If no CREATE/ALTER SCHEMA statement has been issued then an implicit ALTER SCHEMA is issued in contexts where they are allowed (e.g., from an SQL connection).

A domain cannot be dropped that is used in a column declaration.

See Also

CREATE DOMAIN