How to Find Table Used in Stored Procedure in SQL Server

Hello to everyone,

In this article, I will talk about how to find tables related to Procedures in SQL Server.

You can also do this using the code below.

SELECT obj.[name] AS 'ProcedureName',
       sed.referenced_entity_name AS 'TableName'
FROM sys.objects AS obj
    INNER JOIN sys.sql_expression_dependencies AS sed
        ON obj.object_id = sed.referencing_id
WHERE obj.[type] = 'P'
ORDER BY obj.[name];

When you run the code you will get the following result.

As can be seen, the procedure and related tables have been seen.

Good luck to everyone in business and life.