title: SQL Server : search for table/column for a specific data
body: <p>Can you help me locate a for the table and column name for a specific value? See I only know the specific data but no idea where it resides.</p>
  
  <pre><code>SELECT *
  FROM &lt;table_which_i_don't_know_yet&gt;
  WHERE &lt;column_name_which_i_don't_know_yet&gt; = &lt;value_that_i_know_of&gt;
  </code></pre>
  
  <p>What I just found is look for a table with a specific column...</p>
  
  <pre><code>select * 
  from INFORMATION_SCHEMA.COLUMNS 
  where COLUMN_NAME like '%clientid%' 
  order by TABLE_NAME
  </code></pre>