I keep needing to go off and search for this, so as a note to myself, here's the required SQL to find out where tables and columns are referenced in SQL Server stored procedures.
select * from information_schema.routines where routine_definition like '%tablename%'
I believe this only searches the first 4000 characters of the stored procedure, but this has generally been enough for my needs.
No comments:
Post a Comment