Write a query to search tables where first three letters of table are 'pro' in SQL Server 2008?
Udit Sharma
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%'''