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.