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
