디비랑[dɪ'bɪraŋ]

/********************************************************************************************
-- Title : [2k5] 해당 테이블의 자식 테이블 찾기
-- Key word : sys.foreign_key_columns references 자식 테이블
********************************************************************************************/
DECLARE @sch_tbl sysname;
SET @sch_tbl = N'schema._name.table_name';

SELECT name + N'.' + SCHEMA_NAME(SCHEMA_ID)
FROM sys.objects
WHERE OBJECT_ID IN (SELECT parent_object_id
                    FROM sys.foreign_key_columns
                    WHERE referenced_object_id IN (OBJECT_ID(@sch_tbl))
                   );