DOMAIN_CONSTRAINTS (Transact-SQL)

Returns one row for each alias data type in the current database that has a rule bound to it and that can be accessed by current user.

To retrieve information from these views, specify the fully qualified name of **INFORMATION_SCHEMA.**view_name.

Column name	Data type	Description
CONSTRAINT_CATALOG	nvarchar(128)	Database in which the rule exists.
CONSTRAINT_SCHEMA	nvarchar(128)	Name of schema that contains the constraint.
CONSTRAINT_NAME	sysname	Rule name.
DOMAIN_CATALOG	nvarchar(128)	Database in which the alias data type exists.
DOMAIN_SCHEMA	nvarchar(128)	Name of schema that contains the alias data type.
DOMAIN_NAME	sysname	Alias data type.
IS_DEFERRABLE	varchar(2)	Specifies whether constraint checking is deferrable. Always returns NO.
INITIALLY_DEFERRED	varchar(2)	Specifies whether constraint checking is at first deferred. Always returns NO.

See Also