To find out which stored procedure is using a particular table

[sowmyavenkat]

hi all,
Iam working on a Maintainance and enhancement project. It was developed by somebody. Now there is a bug which is to be solved. Can any body help me to find out which stored procedure is using a particulat table.

[ronverdonk]

As far as I know you must use the

SHOW PROCEDURE CODE

command and parse the result for any table usage. But there may be someone in this forum that knows more about this than I do currectly.

Ronald :cool: