select 
    c_c_u.table_name sr_c_table, 
    c_c_u.constraint_name sr_c_constraint, 
    c_c_u.column_name sr_c_col, 
    k_c_u.table_name target_table, 
    k_c_u.column_name target_col
from INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE c_c_u, 
    INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS r_c, 
    INFORMATION_SCHEMA.KEY_COLUMN_USAGE k_c_u
where c_c_u.constraint_name = r_c.constraint_name 
and k_c_u.constraint_name = r_c.unique_constraint_name
order by c_c_u.table_name, 
c_c_u.constraint_name

Republished from http://www.sqlserver-dba.com.