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