Any constraints associated with the domain are moved into the new schema as well. This form changes the schema of the domain. This form changes the name of the domain. This form changes the owner of the domain to the specified user. This form validates a constraint previously added as NOT VALID, that is, it verifies that all values in table columns of the domain type satisfy the specified constraint. This form changes the name of a constraint on a domain. If IF EXISTS is specified and the constraint does not exist, no error is thrown.

NOT VALID is only accepted for CHECK constraints. Newly inserted or updated rows are always checked against all constraints, even those marked NOT VALID. These checks can be suppressed by adding the new constraint using the NOT VALID option the constraint can later be made valid using ALTER DOMAIN. When a new constraint is added to a domain, all columns using that domain will be checked against the newly added constraint. This form adds a new constraint to a domain using the same syntax as CREATE DOMAIN.

You can only SET NOT NULL when the columns using the domain contain no null values. These forms change whether a domain is marked to allow NULL values or to reject NULL values. Note that defaults only apply to subsequent INSERT commands they do not affect rows already in a table using the domain. These forms set or remove the default value for a domain.

Domain Checker 8.2 download the new