To detect the foreign key and it's related information for the particular table or across all the tables

Select

object_name(rkeyid) Parent_Table,

object_name(fkeyid) Child_Table,

object_name(constid) FKey_Name, --from sys.sysforeignkeys

c1.name FKey_Col,

c2.name Ref_KeyCol

From

sys.sysforeignkeys s

Inner join sys.syscolumns c1

on ( s.fkeyid = c1.id And s.fkey = c1.colid )

Inner join syscolumns c2

on ( s.rkeyid = c2.id And s.rkey = c2.colid )

--where object_name(rkeyid)like 'Regulatorytext'

Order by Parent_Table,Child_Table