Andy Jarrett // Code. Develop. Manage.

Search all MSSQL databases on a server for a table

I use MSSQL/T-SQL just enough to be dangerous with it. Though the other day I knew I had a table in one of the many dev databases but could I find it ..... no!

This script loops through ALL databases on a server looking for table called "tableNameYouAreSearchingFor"

I’m here, learning and working away. If you liked this content and want to keep me going, consider buying me a coffee.
Your support keeps this site running and the coffee brewing! ☕️