DOMAIN_CONSTRAINTS – INFORMATION SCHEMA.
– Identifies user defined datatype that have constraints
CREATE VIEW INFORMATION_SCHEMA.DOMAIN_CONSTRAINTS
AS
SELECT
db_name() AS CONSTRAINT_CATALOG,
schema_name(o.schema_id) AS CONSTRAINT_SCHEMA,
o.name AS CONSTRAINT_NAME,
db_name() AS DOMAIN_CATALOG,
schema_name(t.schema_id) AS DOMAIN_SCHEMA,
t.name AS DOMAIN_NAME,
‘NO’ AS IS_DEFERRABLE,
‘NO’ AS INITIALLY_DEFERRED
FROM
sys.types t
JOIN sys.objects o ON o.object_id = t.rule_object_id
WHERE
t.user_type_id > 256
———–