Getting primary foreign key relationships between tables in SQL Server

How to obtain primary foreign key relationships in SQL Server 2008:

Transferred from: http://www.cnblogs.com/ke10/archive/2012/06/11/2544655.html

SELECT object_name (con.constid) ' Relationship name ',
object_name (Sf.fkeyid) ' primary key table ',
Fcol.name ' primary key ',
object_name (Sf.rkeyid) ' foreign key table ',
Rcol.name ' foreign key ',
St.name ' data type '
From Sysforeignkeys SF
INNER JOIN sysconstraints con on sf.constid = Con.constid
INNER JOIN sys.syscolumns fcol on fcol.id = Sf.fkeyid
and fcol.colid = Sf.fkey
INNER JOIN sys.syscolumns rcol on rcol.id = Sf.rkeyid
and rcol.colid = Sf.rkey
INNER JOIN sys.systypes st on fcol.type = St.type

Getting primary foreign key relationships between tables in SQL Server