To search the table name against all databases.

-- to hold the all table names
DECLARE @TableDetail TABLE ( TableName VARCHAR(128)
, DBName VARCHAR(128)
)
-- inserting the each table from each database
INSERT @TableDetail(TableName
, DBName
)
EXEC sp_MSforeachdb @command1='use [?]; SELECT name ,''[?]'' FROM sys.tables'
--search specific table name
SELECT TableName
, DBName
FROM @TableDetail WHERE TableName LIKE '%SalesHistory%'