Tuesday, 10 June 2014

How to get list of all stored procs/functions/view which refer a table?

SELECT OBJECT_NAME(object_id)
FROM sys.sql_modules
WHERE definition LIKE '%table1%'

No comments:

Post a Comment