Steve Fenton

Find Stored Procedures that Reference a Table

If you need to find stored procedures that reference a table in a SQL database, you can use this script. Just update the table name in the script. The script returns all objects that reference the table, including stored procedures.

FROM syscomments sc
INNER JOIN sysobjects so ON =
WHERE sc.TEXT LIKE '%tblExample%'

Written by Steve Fenton on