title: SQL Server Dependencies missing
body: <p>This may be a case of my ignorance to what is meant by a dependency.</p>
  
  <p>When I run the following query I get a slightly different list (more entries) to when I chose the menu option View Dependencies (first node level only) why would that be? I should add I am ignoring VIEW dependencies, for example I have a 2 foreign key relationships set up to 2 different tables (pretty much identical configuration) yet only 1 is shown in the View Dependencies yet both a seen in the following query.</p>
  
  <p>I got this off some other post:</p>
  
  <pre><code>SELECT DISTINCT 
      pt.object_id PrimaryTableID, pt.name PrimaryTableName
  FROM 
      REPDEV.sys.foreign_keys fk
  JOIN 
      REPDEV.sys.tables ft ON fk.referenced_object_id = ft.object_id
  JOIN 
      REPDEV.sys.tables pt ON fk.parent_object_id = pt.object_id
  WHERE 
      ft.name = 'MyTable'
  ORDER BY 
      2
  </code></pre>
  
  <p>Am I suppose to use other means to get table relationship dependencies?</p>