List all Table in the Database

-- 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%'