26 jan 2012

find dependent objects from sql table

BEGIN
set @Tablename= 'tablename'
declare @tablename as nvarchar(max)
Select Distinct
o.Name 'TableName',
op.Name 'DependentObject',
op.XType 'objecttype'
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' and o.Name= @Tablename
END

Geen opmerkingen:

Een reactie posten