I need to search if a stored procedure references a certain table.
The problem is that there are plenty of stored procedures, so doing it by hand will be quiet slow
Is there any data dictionary table (like in Oracle) where the source code of stored procedures is saved?
Or how can i perform the task stated above quickly?
Pinned topic Source code of stored procedures
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-08-16T09:13:50Z at 2012-08-16T09:13:50Z by andreasl
andreasl 100000CHVU387 Posts
Re: Source code of stored procedures2012-08-16T09:13:50ZThis is the accepted answer. This is the accepted answer.Hello Alejandro,
this might serve as a starting point:
select data from sysprocbody where datakey= "T" order by procid, seqno;