How to Find Which Stored Procedure Used the Table in SQL Server
Hello to everyone,
In this article, I will provide information about finding which Stored Procedures a table is used in in SQL Server.
In SQL Server in some cases you may want to find out which Stored Procedures a table is used in.
You can easily do this using the code below.
SELECT ROUTINE_NAME, ROUTINE_DEFINITION FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%Products%' AND ROUTINE_TYPE = 'PROCEDURE';
When you run the above code, you will see a result similar to the one below.
As you can see, we have found in which Stored procedures the table is used.
Good luck to everyone in business and life.