Here I will explain SQL
Server query to get a list of stored procedures where table is used or SQL
query to get list of procedures which contains table name in SQL
In previous posts I explained can function return multiple values in SQL Server, Difference between view & stored procedure in SQL, update multiple tables using inner join in SQL Server many articles relating to SQL Server, asp.net, IIS, etc. Now I will explain how to get list procedures which contains particular table in SQL Server.
If we want to get list procedures which contains particular table name we need to write the query like as shown below
SELECT Name FROM sys.procedures WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%YourTableName%'
SELECT Name FROM sys.procedures WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%UserInformation%'
Once we run above query we will get output like as shown below
I hope it helps you to get list of required stored procedures which contains particular table name. Happy Coding………