sql - How to find all referenced to stored procedure -

sql - How to find all referenced to stored procedure -

i have stored procedure , need alter it. way drop , create, can drop references! way check, if reference procedure.

select name [stored procedure name] sys.procedures object_definition(object_id) '%sp_name%' , object_definition(object_id) '%sp_name%'

above query give stored procedures name sp used.(edit "sp_name" stored procedure name want search with)

sql stored-procedures db2