Topic
  • 1 reply
  • Latest Post - ‏2012-08-16T09:13:50Z by andreasl
alehernandezangeles
alehernandezangeles
1 Post

Pinned topic Source code of stored procedures

‏2012-08-15T18:31:59Z |
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?
Updated on 2012-08-16T09:13:50Z at 2012-08-16T09:13:50Z by andreasl
  • andreasl
    andreasl
    372 Posts

    Re: Source code of stored procedures

    ‏2012-08-16T09:13:50Z  
    Hello Alejandro,

    this might serve as a starting point:

    
    select data from sysprocbody where datakey=
    "T" order by procid, seqno;
    


    HTH,
    Andreas