Search for an Object (Table,View,Stored Procedure etc.) in SQL Server Instance - TSQL Tutorial

How to Find Object ( Table.View,Stored Procedure,Function etc.) in All the Database in SQL Server - TSQL Tutorial / SQL Server Tutorial
On daily basis we come across different questions and scenarios as Database developers and DBAs. Sometime users just stop by and they ask us questions and tell us that they have a table in one of the database and if we can take a look for them. When we try to find out the table, we don't see the table.The table might be in different Database and user is not providing correct information.

The below script can be used to find out any object on Entire SQL Server Instance. you can use this script

To find a Table in all the Databases on SQL Server Instance
To find a Stored Procedure in All the Databases on SQL Server Instance
To find a view on entire SQL Server Instance
To find a function in any database on SQL Server Instance.

In short any object can be found by using below script. You only have to provide the name of object and it will return you information with Database Name, Schema Name, Object Name, Type and Type Description. The below code is also one of the example where we need to change the database name in our query and we can use Dynamic SQL to perform that.

Blog post link the video with scripts

[masimatta]

English ni ati to lazmi hae k app english bolain