title: given a foreign key, how do i find all tables that use that particular key?
body: <p>i have a column (myColumn) that serves as the primary key of a table (tableA).
  i've noticed that 2 or 3 tables reference this myColumn as foreign key.
  how do i detect all tables that use and reference myColumn?</p>
  
  <p>im guessing that more than 3 tables use myColumn because when i tried updating it like this</p>
  
  <pre><code>UPDATE tableA
  SET myColumn = 1
  WHERE myColumn = 1
  </code></pre>
  
  <p>6 rows were updated.</p>
  
  <p>it was earlier suggested to me to use </p>
  
  <pre><code>sp_helpconstraint('your_table_name')
  </code></pre>
  
  <p>but i then found out that this does not give the complete information that i need.</p>
  
  <p>any other suggestions?</p>