How to find the dependent objects of stored procedure in sql server?

sp_depends is the system stored procedure which is used to fetch the dependent objects of any database objects.

Syntax to find out the dependent objects of a stored procedure is :

sp_depends <Stored Procedure Name>


Example  to find out the Dependent objects of stored procedure USP_CLASS_OF_STUD is:

sp_depends USP_CLASS_OF_STUD




This entry was posted in . Bookmark the permalink.

Leave a reply