Subject Listing Stored Procedure In Order of Dependencies
Author LtColRDSChauhan
Hello,
I need to update several procedures in my database.
For that, how can I list my stored procedures ordered on dependencies as under :
---------------------------------------
Stored           Dependencies
Procedures   if any IN
---------------------------------------
SP_1           NONE
SP_2           (SP_1)
SP_3           (SP_1, SP_2)
.
.
SP_n          (SP_1, SP_2, ...
                    SP_n-1)
---------------------------------------
Regards,
Rajiv