title: Find a database with a particular table OR Find a table in every database of SQL Server
body: <p>I have a SQL Server with hundreds of databases and each database having hundreds of tables.
  Now I would like to find where in these databases is a table that I am looking for.</p>
  
  <p>I could find if a table existed in individual database using </p>
  
  <pre><code>use myDatabase 
  select * from sys.tables  where name = 'mytable' 
  GO
  </code></pre>
  
  <p>but using this means I have to manually change the database for hundreds of times .
  I would like to find the database name only.
  Is there a way out ?</p>