Query to check the tables part of procedures

SQLServerCentral » Latest topics

Query to check the tables part of procedures

Hi,

Though sp_depends 'proc_name' displays all the tables which are part of the procedure but if the tables are part of dynamic query it never appears. Is there anyway to get the details?

I mostly use this query

more info...