3
Reply

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

Udit Sharma

Udit Sharma
7y
170
0
Reply
    Subash

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

    Subash
    6y
    1
    Mohit Methi

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

    Mohit Methi
    6y
    0
    Subash

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

    Subash
    6y
    0
Message