select t1.constraint_object_id AS id, t3.name AS PKTABLE_OWNER, t2.name AS PKTABLE_NAME, t21.name AS PKCOLUMN_NAME,
	t5.name AS FKTABLE_OWNER, t4.name AS FKTABLE_NAME, t41.name AS FKCOLUMN_NAME 
from sys.foreign_key_columns t1 
	inner join sys.objects t2 on t2.object_id = t1.parent_object_id 
	inner join sys.schemas t3 on t2.schema_id = t3.schema_id 
	inner join sys.columns t21 on t21.object_id = t2.object_id and t21.column_id = t1.parent_column_id 
	inner join sys.objects t4 on t4.object_id = t1.referenced_object_id 
	inner join sys.schemas t5 on t5.schema_id = t4.schema_id 
	inner join sys.columns t41 on t41.object_id = t4.object_id and t41.column_id = t1.referenced_column_id 
where EXISTS (select  1  from information_schema.tables s 
				where s.TABLE_SCHEMA=t5.name and s.table_name = t4.name 
					and s.table_type = 'Base table' ) 
order by t1.constraint_object_id, t1.constraint_column_id