INFORMATION SCHEMA. CONSTRAINT TABLE_USAGE
– Identifies tables that have constraints
CREATE VIEW INFORMATION_SCHEMA.CONSTRAINT_TABLE_USAGE
AS
SELECT
db_name() AS TABLE_CATALOG,
schema_name(t.schema_id) AS TABLE_SCHEMA,
t.name AS TABLE_NAME,
db_name() AS CONSTRAINT_CATALOG,
schema_name(c.schema_id) AS CONSTRAINT_SCHEMA,
c.name AS CONSTRAINT_NAME
FROM
sys.objects c JOIN sys.tables t
ON t.object_id = c.parent_object_id
WHERE
c.type IN (’C’ ,’UQ’ ,’PK’ ,’F')
——–