WITH FKColumns AS (
	SELECT 
		fk.object_id, 
		parent_object_id, 
		(SELECT '(' + CAST(parent_column_id AS VARCHAR(10))+ ')' FROM sys.foreign_key_columns fkc WHERE fkc.constraint_object_id = fk.object_id AND fkc.parent_object_id = fk.parent_object_id ORDER BY fkc.parent_column_id FOR XML PATH('')) parent_columns,
		referenced_object_id,
		(SELECT '(' + CAST(referenced_column_id AS VARCHAR(10))+ ')' FROM sys.foreign_key_columns fkc WHERE fkc.constraint_object_id = fk.object_id AND fkc.referenced_object_id = fk.referenced_object_id ORDER BY fkc.referenced_column_id FOR XML PATH('')) referenced_columns
	FROM sys.foreign_keys fk
), DupKeys AS (
SELECT 
	'[' + OBJECT_SCHEMA_NAME(fk1.parent_object_id) + '].[' + OBJECT_NAME(fk1.parent_object_id) + ']' TableName, 
	'[' + OBJECT_SCHEMA_NAME(fk1.referenced_object_id) + '].[' + OBJECT_NAME(fk2.referenced_object_id) + ']' ReferencedTable, 
	OBJECT_NAME(fk1.object_id) DuplicateFK,
	OBJECT_NAME(fk2.object_id) OriginalFK
FROM FKColumns fk1
INNER JOIN FKColumns fk2 ON 
	fk1.parent_object_id = fk2.parent_object_id 
	AND fk1.referenced_object_id = fk2.referenced_object_id
	AND fk1.parent_columns = fk2.parent_columns 
	AND fk1.referenced_columns = fk2.referenced_columns
	AND fk1.object_id > fk2.object_id
) 
SELECT 
	* 
FROM DupKeys dk1

TableName	ReferencedTable	DuplicateFK	OriginalFK
[dbo].[T2]	[dbo].[T1]	        FK2	        FK1
[dbo].[T2]	[dbo].[T1]	        FK3	        FK1
[dbo].[T2]	[dbo].[T1]	        FK3	        FK2
[dbo].[T2]	[dbo].[T1]	        FK4	        FK1
[dbo].[T2]	[dbo].[T1]	        FK4	        FK2
[dbo].[T2]	[dbo].[T1]	        FK4	        FK3

CREATE TABLE T1 (C1 INT, C2 INT)
CREATE UNIQUE INDEX T1_Ux1 ON T1 (C1, C2)
CREATE UNIQUE INDEX T1_Ux2 ON T1 (C2, C1)

CREATE TABLE T2 (C1 INT, C2 INT)
ALTER TABLE T2 ADD CONSTRAINT FK1 FOREIGN KEY (C1, C2) REFERENCES T1 (C1, C2)
ALTER TABLE T2 ADD CONSTRAINT FK2 FOREIGN KEY (C2, C1) REFERENCES T1 (C2, C1)
ALTER TABLE T2 ADD CONSTRAINT FK3 FOREIGN KEY (C1, C2) REFERENCES T1 (C1, C2)
ALTER TABLE T2 ADD CONSTRAINT FK4 FOREIGN KEY (C2, C1) REFERENCES T1 (C2, C1)

;WITH FKColumns AS (
	SELECT 
		fk.object_id, 
		parent_object_id, 
		(SELECT '(' + CAST(parent_column_id AS VARCHAR(10))+ ')' FROM sys.foreign_key_columns fkc WHERE fkc.constraint_object_id = fk.object_id AND fkc.parent_object_id = fk.parent_object_id ORDER BY fkc.parent_column_id FOR XML PATH('')) parent_columns,
		referenced_object_id,
		(SELECT '(' + CAST(referenced_column_id AS VARCHAR(10))+ ')' FROM sys.foreign_key_columns fkc WHERE fkc.constraint_object_id = fk.object_id AND fkc.referenced_object_id = fk.referenced_object_id ORDER BY fkc.referenced_column_id FOR XML PATH('')) referenced_columns
	FROM sys.foreign_keys fk
), DupKeys AS (
SELECT 
	min(fk1.object_id) parentFK_id,
	fk1.parent_object_id, 
	fk1.referenced_object_id
FROM FKColumns fk1
GROUP BY fk1.parent_object_id, fk1.parent_columns, fk1.referenced_object_id, fk1.referenced_columns
HAVING COUNT(*) > 1
)
SELECT 	'[' + OBJECT_SCHEMA_NAME(dk1.parent_object_id) + '].[' + OBJECT_NAME(dk1.parent_object_id) + ']' TableName, 
	'[' + OBJECT_SCHEMA_NAME(dk1.referenced_object_id) + '].[' + OBJECT_NAME(dk1.referenced_object_id) + ']' ReferencedTable, 
	OBJECT_NAME(fk1.object_id) DuplicateFK,
	OBJECT_NAME(dk1.parentFK_id) OriginalFK
FROM DupKeys dk1
	INNER JOIN FKColumns fk1 ON 
		fk1.parent_object_id = dk1.parent_object_id and 
		fk1.referenced_object_id = dk1.referenced_object_id and
		fk1.object_id <> dk1.parentFK_id