get foreign key detail

SELECT OBJECT_NAME(object_id) AS ConstraintName,
lower(replace(type_desc,'_',' ')) + ' in table: ' + SCHEMA_NAME(schema_id) + '.' + OBJECT_NAME(parent_object_id) AS TableName
FROM sys.objects
WHERE type_desc LIKE '%CONSTRAINT' and SCHEMA_NAME(schema_id) = 'metadata'
order by OBJECT_NAME(parent_object_id),ConstraintName


SELECT OBJECT_NAME(a.object_id) AS 'Constraint Name',
t.name + '.' + c.name +' map with ' + r.name + '.' + d.name as 'Constraint Detail',
lower(replace(a.type_desc,'_',' ')) + ' in table: ' + SCHEMA_NAME(a.schema_id) + '.' + OBJECT_NAME(a.parent_object_id) AS TableName,
*
FROM sys.objects a
--primary key detail
--foreign key detail
left join
    sys.foreign_key_columns as fk on a.object_id = fk.constraint_object_id
left join
    sys.tables as t on fk.parent_object_id = t.object_id
left join
    sys.tables as r on fk.referenced_object_id = r.object_id
left join
    sys.columns as c on fk.parent_object_id = c.object_id and fk.parent_column_id = c.column_id
left join
    sys.columns as d on fk.referenced_object_id = d.object_id and fk.referenced_column_id = d.column_id
--default constraint detail
--left join
--	sys.columns as dfc on a.object_id = dfc.object_id
WHERE a.type_desc LIKE '%CONSTRAINT' and SCHEMA_NAME(a.schema_id) = 'metadata'
order by OBJECT_NAME(a.parent_object_id),'Constraint Name'