Subject | Listing Stored Procedure In Order of Dependencies |
---|---|
Author | LtColRDSChauhan |
Post date | 2017-07-20T04:42:16Z |
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