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

home / software / tips and tricks / 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.

alt="Add your business to our listing Free"