Get All Dependent SPs and Tables

Get All Dependent SPs and Tables

SELECT DISTINCT SysObjects.Name 'Table Name', Procedures.Name 'Stored Procedure'

FROM SysObjects

JOIN (SysObjects Procedures

JOIN SysDepends

ON Procedures.Id = SysDepends.Id)

ON SysDepends.DepId = SysObjects.Id

WHERE SysObjects.XType = 'U'

AND Procedures.XType = 'P'

-- AND sysobjects.name = 'EFSFilterData' --Filter Criteria goes here

GROUP BY SysObjects.Name, SysObjects.Id, Procedures.Name

ORDER BY SysObjects.Name Asc

 

--DB