Microsoft SQL Server manual

## Find out a table 

select * from sys.tables where name like '%doc_module_verification%'

EXEC
 
sys.sp_msforeachdb 
    
'SELECT ''?'' DatabaseName, Name FROM [?].sys.Tables 
WHERE Name LIKE ''%prospect%'''