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.