Write a query to search tables where first three letters of table are 'pro' in SQL Server 2008?

3

Reply

Write a query to search tables where first three letters of table are 'pro' in SQL Server 2008?

Udit Sharma

8y

208

0

Subash

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

8y

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

7y

Subash

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

8y