title: How to find tables and columns containing specified column value
body: <p>In T-SQL is it possible to give me a list of tables and columns that contain specified column value? </p>
  
  <p>For example, I get a employee report generated out of a SQL Server database that shows "John" as name in one of the columns. Now I want to find out where "John" appears as a field value in any table/column in the database. </p>
  
  <p>So in English my query should sound like;</p>
  
  <pre><code>Select table, column 
  from database A 
  where field = 'John'
  </code></pre>
  
  <p>Thanks</p>