Contents

1 2005

2 2008

select 
	object_name(fkeyid) 참조하는
,	object_name(rkeyid) 참조당하는
from sys.sysreferences

--참조하는 엔터티들
SELECT * 
 FROM sys.dm_sql_referencing_entities ('dbo.Product', 'OBJECT');
 GO

--참조되는(당하는) 엔터티들 
SELECT * 
 FROM sys.dm_sql_referenced_entities('dbo.spc_UpdateProductDetail', 'OBJECT')
GO