Query below finds all databases in SQL Server instance containing particular table (table name must include schema name). In this case this table is dbo.version.
select [name] as [database_name] from sys.databases where case when state_desc = 'ONLINE' then object_id(quotename([name]) + '.[dbo].[version]', 'U') end is not null order by 1
- database_name - database names
- One row represents one database
- Scope of rows: all databases containing provided table schama and name
- Ordered by database name
All databases containing dbo.version table - that's how if search for Dataedo repositories.