SQL database view primary FOREIGN Key Association

SELECT primary key Column Id=b.rkey
, primary key Column name = (SELECT name from syscolumns WHERE Colid=b.rkey and Id=b.rkeyid)
, FOREIGN key table Id=b.fkeyid
, foreign key table name =object_name (B.fkeyid)
, Foreign key column Id=b.fkey
, foreign key Column name = (SELECT name from syscolumns WHERE Colid=b.fkey and Id=b.fkeyid)
Cascade Update =objectproperty (a.id, ' Cnstisupdatecascade ')
, cascade delete =objectproperty (a.id, ' Cnstisdeletecascade ')
From sysobjects a
Join Sysforeignkeys B on A.id=b.constid
Join sysobjects C on a.parent_obj=c.id
Where a.xtype= ' F ' and c.xtype= ' U '
and object_name (B.rkeyid) = ' Tb_common_user '

SQL database view primary FOREIGN Key Association