DROP DOMAIN Statement

statement_DROP_DOMAIN ::= DROP [ IF EXISTS ] DOMAIN [scheme.]domain_name [ CASCADE | RESTRICT ]

The DROP DOMAIN statement deletes an existing domain. If this domain is used in table definitions, the statement behaviour depends on the CASCADE or RESTRICT specification:

If CASCADE is stated, all tables using this domain will be deleted.
If RESTRICT is stated (or neither option is set), the error W0162 (REFERENCED_BY_OTHER_OBJECT) occurs and the domain is not deleted.

If a domain of the specified name does not exist in the schema the error sqlstate W0137 (OBJECT_DOES_NOT_EXIST) occurs.

See

CREATE DOMAIN
ALTER DOMAIN

ALTER DOMAIN Statement

SQL Statements

CREATE VIEW Statement