A ‘search for reference’ feature to search all DDL for a particular word?

[iceman]

For example, Suppose I change stored procedure ‘MyProc’ to accept a parameter when it didn’t before.

Now I need to search through all the other views, procedures functions etc to find the places places where ‘MyProc’ is used and modify the code there in order to to pass a parameter. (Same problem with a simple table rename.)

Currently I do an database dump to a text file and search that huge file in Notepad, but it would be very convenient if there was a feature where you could enter the name of a table, proc, view, function etc., (or even an arbitrary phrase) and SQLyog would list all the places in the database schema where that name is referenced.

[Sibin A S]

No. This option is not available.

[Author]

Posts