DECLARE @SCHEMA_NAME sysname,@TABLE_NAME sysname;
SELECT @SCHEMA_NAME=N'dbo',@TABLE_NAME=N'ИмяТаблицы';
SELECT
 CAST(QUOTENAME(FK.TABLE_CATALOG)+'.'+QUOTENAME(FK.TABLE_SCHEMA)+'.'+QUOTENAME(FK.TABLE_NAME)+'.'+QUOTENAME(FK.COLUMN_NAME) AS NVARCHAR(530))[Колонка],
 CAST(QUOTENAME(PK.TABLE_CATALOG)+'.'+QUOTENAME(PK.TABLE_SCHEMA)+'.'+QUOTENAME(PK.TABLE_NAME)+'.'+QUOTENAME(PK.COLUMN_NAME) AS NVARCHAR(530))[ссылается на]
FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE PK
JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS C ON PK.CONSTRAINT_CATALOG=C.UNIQUE_CONSTRAINT_CATALOG AND PK.CONSTRAINT_SCHEMA=C.UNIQUE_CONSTRAINT_SCHEMA AND PK.CONSTRAINT_NAME=C.UNIQUE_CONSTRAINT_NAME
JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE FK ON C.CONSTRAINT_CATALOG=PK.CONSTRAINT_CATALOG AND C.CONSTRAINT_SCHEMA=FK.CONSTRAINT_SCHEMA AND C.CONSTRAINT_NAME=FK.CONSTRAINT_NAME AND PK.ORDINAL_POSITION=FK.ORDINAL_POSITION
WHERE PK.TABLE_CATALOG=DB_NAME() AND PK.TABLE_SCHEMA=@SCHEMA_NAME AND PK.TABLE_NAME=@TABLE_NAME
   OR FK.TABLE_CATALOG=DB_NAME() AND FK.TABLE_SCHEMA=@SCHEMA_NAME AND FK.TABLE_NAME=@TABLE_NAME
ORDER BY PK.CONSTRAINT_NAME,FK.CONSTRAINT_NAME,PK.ORDINAL_POSITION;

DECLARE @table_name VarChar(255)
SET @table_name='Нужная_таблица' 
SELECT CCU.TABLE_NAME,CCU.COLUMN_NAME,CCU1.TABLE_NAME,CCU1.COLUMN_NAME FROM INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE  AS CCU
LEFT OUTER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS RC
ON CCU.CONSTRAINT_NAME = RC.CONSTRAINT_NAME
LEFT OUTER JOIN INFORMATION_SCHEMA.CONSTRAINT_COLUMN_USAGE CCU1
ON CCU1.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME
WHERE CCU.TABLE_NAME=@table_name AND CCU.CONSTRAINT_NAME IN (SELECT TC.CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS TC WHERE TC.CONSTRAINT_TYPE='FOREIGN KEY')

SELECT 
C.TABLE_NAME FK_TABLE , 
C.COLUMN_NAME FK_COLUMN, 
D.TABLE_NAME PK_TABLE , 
D.COLUMN_NAME PK_COLUMN,
D.CONSTRAINT_NAME pCONSTRAINT_NAME
FROM
(
SELECT
B.TABLE_NAME
,
COLUMN_NAME
,B.CONSTRAINT_NAME
FROM
  SYS.USER_CONS_COLUMNS B
  ,SYS.USER_CONSTRAINTS  A
WHERE
  A.CONSTRAINT_NAME = B.CONSTRAINT_NAME
  AND  A.CONSTRAINT_TYPE = 'R'
) C,
(
SELECT
 b.TABLE_NAME,
 COLUMN_NAME
, A.CONSTRAINT_NAME
FROM
  SYS.USER_CONS_COLUMNS B
  ,SYS.USER_CONSTRAINTS  A
WHERE
  B.CONSTRAINT_NAME = A.R_CONSTRAINT_NAME
) D
WHERE   C.CONSTRAINT_NAME =  D.CONSTRAINT_NAME
)

DECLARE @Lev int

SET @Lev = 1
/* Bce таблицы верхнего уровня */
SELECT @Lev AS LEV, TT.TABLE_NAME, CC.CONSTRAINT_NAME INTO #TmpTab 
FROM INFORMATION_SCHEMA.TABLES TT 
LEFT OUTER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS CC ON CC.TABLE_NAME = TT.TABLE_NAME AND CC.CONSTRAINT_TYPE = 'PRIMARY KEY'
WHERE TT.TABLE_TYPE = 'BASE TABLE' AND TT.TABLE_NAME NOT LIKE 'sys%' AND TT.TABLE_NAME NOT LIKE 'dtprop%'
AND NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS TC WHERE TC.TABLE_NAME = TT.TABLE_NAME 
AND TC.CONSTRAINT_TYPE = 'FOREIGN KEY')

WHILE @@ROWCOUNT > 0 AND @Lev < 99 
BEGIN
SET @Lev = @Lev + 1
/* Все таблицы которые имеют набор 'FOREIGN KEY', где они все ссылаются на ранее вставленые записи */
INSERT INTO #TmpTab(LEV, TABLE_NAME, CONSTRAINT_NAME) 
SELECT @Lev AS LEV, TABLE_NAME, CONSTRAINT_NAME FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS TT 
WHERE TT.CONSTRAINT_TYPE = 'PRIMARY KEY' AND TT.TABLE_NAME NOT LIKE 'sys%' AND TT.TABLE_NAME NOT LIKE 'dtprop%'
AND TABLE_NAME NOT IN (SELECT TABLE_NAME FROM #TmpTab )
AND NOT EXISTS (SELECT 1 FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS LT
INNER JOIN INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS RC ON LT.CONSTRAINT_NAME = RC.CONSTRAINT_NAME AND NOT EXISTS (SELECT CONSTRAINT_NAME FROM #TmpTab TM WHERE RC.UNIQUE_CONSTRAINT_NAME = TM.CONSTRAINT_NAME) --UNIQUE_CONSTRAINT_NAME NOT IN (SELECT CONSTRAINT_NAME FROM #TmpTab ) 
WHERE TT.TABLE_NAME = LT.TABLE_NAME AND LT.CONSTRAINT_TYPE = 'FOREIGN KEY')
END
/* Таблицы попавшие в петлю или невошедшие в список по другим причинам */
INSERT INTO #TmpTab(LEV, TABLE_NAME, CONSTRAINT_NAME) 
SELECT 100, TT.TABLE_NAME, ''
FROM INFORMATION_SCHEMA.TABLES TT 
WHERE TT.TABLE_TYPE = 'BASE TABLE' AND TT.TABLE_NAME NOT LIKE 'sys%' AND TT.TABLE_NAME NOT LIKE 'dtprop%'
AND NOT EXISTS( SELECT 1 FROM #TmpTab WHERE TABLE_NAME = TT.TABLE_NAME)

SELECT * FROM #TmpTab ORDER BY LEV, TABLE_NAME
DROP TABLE #TmpTab