title: how to find tables that have column values if i don't know the table
body: <p>We have an application used at work that was created by a third party. So we have access to the UI and not the backend code. On this application there is a dropdown list. I do have access to the MSSQL DB that this application runs on.</p>
  
  <p>I need to know where this dropdown list gets its info from but I don't know which table it uses (because I cant check the code directly). </p>
  
  <p>Is there a query I can write to search the entire DB for tables that have columns that contain a specific value ?</p>
  
  <p>The dropdownlist values are:</p>
  
  <ul>
  <li>WebsiteAPP</li>
  <li>BOT App</li>
  <li>Walkin</li>
  <li>BotLead</li>
  </ul>