SELECT name AS TableName FROM sys.tables WHERE name LIKE 'pro%'

Select * from INFORMATION_SCHEMA.TABLES Where TABLE_NAME LIKE 'Pro%'

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