title: how to find foreign key mapping?
body: <p>I have a Database in MS SQL Server 2008 .</p>
  
  <p>It has a table  BRANCH.</p>
  
  <p>this table has a column BRANCH_ID. This is a foreign key to another table.</p>
  
  <p>I want to find to which table this foreign key is mapped.   How do I find it ?</p>
  
  <p>(I am using MS SQL Server Management Studio 2008)</p>