You can get the relationship columns and their respective table from sql server by just using the following query:

SELECT object_name(rkeyid) MasterTable
,scpk.name MasterColumns
,object_name(fkeyid) ChildTable
,scfk.name ChildColumns
FROM sysforeignkeys  sfk
INNER JOIN syscolumns scfk ON sfk.fkeyid = scfk.id AND sfk.fkey = scfk.colid
INNER JOIN syscolumns scpk ON sfk.rkeyid = scpk.id AND sfk.rkey = scpk.colid
ORDER BY rkeyid,fkeyid,keyno

Two system tables(syscolumns, sysforeignkeys ) are required to get this information

Hope this may help anyone.