Mimer SQL Reference Manual TOC PREV NEXT INDEX

Mimer Developer Site

www.mimer.com/developer


DOMAIN_CONSTRAINTS


The DOMAIN_CONSTRAINTS system view lists the domain constraints of domains to which the current ident has access.

Column name
Data type
Description
CONSTRAINT_CATALOG
VARCHAR(128)
The name of the catalog containing the constraint.
CONSTRAINT_SCHEMA
VARCHAR(128)
The name of the schema containing the constraint.
CONSTRAINT_NAME
VARCHAR(128)
Name of the constraint.
DOMAIN_CATALOG
VARCHAR(128)
The name of the catalog containing the domain on which the constraint is defined.
DOMAIN_SCHEMA
VARCHAR(128)
The name of the schema containing the domain on which the constraint is defined.
DOMAIN_NAME
VARCHAR(128)
The name of the domain on which the constraint is defined.
IS_DEFERRABLE
VARCHAR(3)
One of:
"YES" = the constraint is deferrable
"NO" = the constraint is not deferrable.
INITIALLY_DEFERRED
VARCHAR(3)
One of:
"YES" = the constraint is immediate
"NO" = the constraint is deferred.



Upright Database Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40
dbtechnology@upright.se
Mimer SQL Reference Manual TOC PREV NEXT INDEX