A few days ago, I had to rename a database column for some uncontrollable reasons. Well, I searched for all the code pages in the project and replaced the column. But the daunting part was that I didn’t know about all the SPs that used that particular column name. So I had to search for the query which can look through all the stored procedures and display a list of all the stored procedures which contains the database column. This will make it easier for me to replace the old column with the new column name.
The query for searching for a column name in all the stored procedures of a database is:
Select routine_name, routine_definition
where routine_definition like ‘%OldColumn%’