title: Display all the names of databases containing particular table
body: <p>I have many databases in my SQL Server.</p>
  
  <p>I have to just search for database names containg particular table name <code>Heartbitmaster</code></p>
  
  <p>I have many databases such as <code>Gotgold</code>, <code>DVD</code>, etc and I just want to find database names from query that contain this table <code>Heartbitmaster</code>.</p>
  
  <p>I searched I tried for query:</p>
  
  <pre><code>SELECT 
      TABLE_NAME  
  FROM 
      INFORMATION_SCHEMA.TABLES 
  WHERE 
      TABLE_TYPE = 'base table'   
      AND table_schema = 'Heartbitmaster'
  </code></pre>
  
  <p>but it didn't work.</p>
  
  <p>I searched further and came across:</p>
  
  <pre><code>SELECT name, database_id, create_date
  FROM sys.databases 
  </code></pre>
  
  <p>but dont know how to arrange further where condition for search of table name</p>
  
  <p>Please help me.</p>