DROP DOMAIN

DROP DOMAIN — remove a SQL domain

Syntax

DROP DOMAIN [IF EXISTS] [SCHEMA.]name
DROP DOMAIN [SCHEMA.]name [IF EXISTS]

Description

Removes a SQL domain from the database. (Not to be confused with a NuoDB domain (NuoDB).)
You must own the domain to drop it. If the domain does not exist, and you specify IF EXISTS, NuoDB does not generate an error. Otherwise, if the domain does not exist, an error is generated.
Dropping a domain does not cascade to dropping columns defined in terms of that domain. That is, if any column in any table is defined in terms of the domain specified to be dropped, the definition of that column remains valid and includes all attributes of the dropped domain.

Parameters

Examples