title: Trying to figure out how a table in SQL Server is getting populated
body: <p>There is no documentation and no way to get in touch with the architects of the table. Are there any queries or options in SSMS that allows me to know what the table is connected to ?</p>
  
  <p>A brief explanation of my issue is that there are two tables that seem to be connected.</p>
  
  <p>Table A which contain 10M distinct users and Table B 5M users. All users in Table B are in Table A but obviously Table A's users aren't in Table B. After running multiple tests on the website, I cant find the trigger that copies the user information from Table A to Table B. And that's why I would like to know how Table B gets populated.</p>