Home / Software / Tips and Tricks / How to find the dependent table in a stored procedure in SQL server?

How to find the dependent table in a stored procedure in SQL server?

Updated:  09/11/2013 13:09 PM
Author:  Shiju Mathews

Status:    Resolved.


We can read this information from sysobjects and sysdepends table belong to the system. The query uses a CTE to grab the required results.