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...