Rajanand Ilangovan
Rajanand Ilangovan

Rajanand Ilangovan

Rajanand Ilangovan

Rajanand Ilangovan

5 followers

I'm a Business Intelligence Developer with over a decade of experience in design and development of databases, data warehouse, ETL, business intelligence reports and data visualization/analytics.

How to search for a table or column in all the databases in a server

Nov 17, 20221 min read 6 views

Using T-SQL in SQL Server ยท To search for a table across databases in a server EXEC sp_MSforeachdb 'SELECT "?" AS DB, * FROM [?].sys.tables WHERE name...