SUJOY SANTRA
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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment