Hope this helps you..

SELECT TableName, COUNT(*) [Dependency Count]

FROM (

Select Distinct

o.Name 'TableName',

op.Name 'DependentObject'

From SysObjects o

INNER Join SysDepends d ON d.DepId = o.Id

INNER Join SysObjects op on op.Id = d.Id

Where o.XType = 'U'

Group by o.Name, o.Id, op.Name

) x

GROUP BY TableName

ORDER BY 2 desc

🙂

Kivan G