title: How to determine a table's dependencies?
body: <p>I need to migrate some data between environments. The data structures are going to be exactly the same, however some of the data is ID dependent on existing data which will have to be adapted, or more precisely, userIds (such as ownership, last modification, etc). 
  I have already established as a requirement that usernames on both environments will always refer to the same user, so what I need to do is to determine which columns reference the user table, and transform my data from one environment to the other.</p>
  
  <p>I have tried checking the SQL Server Management Studio's Object dependencies on the user table, and got a detailed list of which objects are referencing the ID column. However, there is at least one table that i know that does refer the ID column that does not appear in the list.</p>
  
  <p><a href="https://i.stack.imgur.com/bAaci.png" rel="nofollow noreferrer">Constraint Options on Table</a></p>
  
  <p><a href="https://i.stack.imgur.com/sIohE.png" rel="nofollow noreferrer">Dependants on the user table</a></p>
  
  <p>Attempting to update a row from the proposal table with an unexisting id displays the expected exception:</p>
  
  <pre class="lang-sql prettyprint-override"><code>Msg 547, Level 16, State 0, Line 1
  The UPDATE statement conflicted with the FOREIGN KEY constraint "OSFRK_OSUSR_tpt_PROPOSAL_OSUSR_A7L_USER_MASTER_CREATEDBY". The conflict occurred in database "databasename", table "dbo.OSUSR_A7L_USER_MASTER", column 'ID'.
  </code></pre>
  
  <p>Can there be any reason for this table to not appear as a dependent on the user's table? Is there a way to determine if there are more tables that are not being displayed?</p>