title: How to determine if a column exists in SQL server DB in other tables with a different name
body: <p>I need to fetch specific hardware data from source tables. The hardware information is present in a table Server_Data with columns as follows, </p>
  
  <pre><code>          Server_ID, Server Property, Property_Value
                 65          Model          Cisco 123
                 65          Name           Cisco abc
  </code></pre>
  
  <p>I need to link this table with System table that has columns as follows, </p>
  
  <pre><code>           System_ID,   System_IP
                   1      10.20.30.40
  </code></pre>
  
  <p>I searched all tables in database but Server_ID column is present only in Server _Data table. Also, I searched all tables if there exists a table that links System_ID with Server_ID, but there is no such table. </p>
  
  <p>I need to find if the Server_ID column is present in any other table with some other name (say Server_Key or just Key). Any help would be appreciated. </p>