A ver si te sirve:
Código SQL:
Ver originalSELECT S.[name] AS 'Tablas que depende de tabla'
FROM sys.objects S INNER JOIN sys.sysreferences R
ON S.object_id = R.fkeyid
WHERE S.[TYPE] = 'U'
AND R.rkeyid = OBJECT_ID('tabla')
SELECT S.[name] AS 'Tablas Dependientes'
FROM sys.objects S INNER JOIN sys.sysreferences R
ON S.OBJECT_ID = R.rkeyid
WHERE S.[TYPE] = 'U' AND
R.fkeyid = OBJECT_ID('tabla')