Please pass your table name in this query and
Get name of all object which are dependent on that
SELECT distinct A.name
FROM syscomments B
INNER JOIN sysobjects A ON B.id = A.id
WHERE charindex('<Table Name>', text) > 0
Get name of all object which are dependent on that
SELECT distinct A.name
FROM syscomments B
INNER JOIN sysobjects A ON B.id = A.id
WHERE charindex('<Table Name>', text) > 0
0 comments:
Post a Comment