CREATE DOMAIN

• Grammar

create_domain

domain_constraint

Specify the underlying data type.

Set the default value for columns of the domain data type.

CONSTRAINT constraint_name

NOT NULL

Do not allow null values.

NULL

Allow null values (default).

CHECK ( expression )

The key word VALUE should be used to refer to the value being tested. Expressions evaluating to TRUE or UNKNOWN succeed.