How to retrieve a list of dependencies for an object in MS SQL:
1. Basic Info
EXEC sp_depends your_object
(It's only showing views and stored procedures for the object.) 2. Added Columns Info
SELECT o1.name 'Procedure',
c2.name 'Column',
d.resultobj 'Updated',
d.readobj 'Read'
FROM sysdepends d
JOIN sysobjects o1
ON d.id = o1.id
JOIN sysobjects o2
ON d.depid = o2.id
JOIN syscolumns c2
ON d.depid = c2.id
AND d.depnumber = c2.colid
WHERE o2.name = 'your_table'
ORDER BY o1.name, c2.colid (Here you can not only see which procedures that references the table, but also which columns they reference.)
| 
