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