"grep" search of Sybase procedures

[DaveMere]

Hi all.

Does anyone know of a way in which I can search all the stored procedures in a database for a particular table name? I have to make a slight change to the structure of one of my tables and would like to know precisely which stored procs I'll have to alter as a result.

Cheers,

DaveMere

 

[moonoo]

Hi ,
You can do a sp_depends on the tablename which will tell you what are the objects in database referencing that table.
Hope this helps..

 

[toring]

This site has many utility procedures, look for sp__grep.

http://www.edbarlow.com/document/procedures/readme.htm