如何在sql server中找到循环依赖表 [英] How to find circular dependent table in sql server

问题描述

目前正在寻找数据库中表的dpendency顺序。因为一些表是循环依赖的没有得到整个订单.....

有什么方法可以在sql server的任何数据库中找到循环依赖表，除了数据库图表

解决方案

您真的不需要购买工具才能找到这些参考。

  SELECT 
 OBJECT_SCHEMA_NAME（fk1.parent_object_id）
 +'。'+ OBJECT_NAME（fk1.parent_object_id），
 OBJECT_SCHEMA_NAME（fk2.parent_object_id）
 +'。'+ OBJECT_NAME（fk2.parent_object_id ）
 FROM sys.foreign_keys AS fk1 
 INNER JOIN sys.foreign_keys AS fk2 
 ON fk1.parent_object_id = fk2.referenced_object_id 
 AND fk2.parent_object_id = fk1.referenced_object_id; 
  

Currently im working on finding the dpendency order of tables in a database. And im stuck up with peoblem of circular depedency of some tables in database.

since some tables are circularly depended im not getting the entire order.....

Is there any way to find circular dependent tables in any database in sql server, Other than the database diagrams??

解决方案

You don't really need to buy a tool to find these references.

SELECT 
  OBJECT_SCHEMA_NAME(fk1.parent_object_id)
   + '.' + OBJECT_NAME(fk1.parent_object_id), 
  OBJECT_SCHEMA_NAME(fk2.parent_object_id)
   + '.' + OBJECT_NAME(fk2.parent_object_id)
FROM sys.foreign_keys AS fk1
INNER JOIN sys.foreign_keys AS fk2
ON fk1.parent_object_id = fk2.referenced_object_id
AND fk2.parent_object_id = fk1.referenced_object_id;

这篇关于如何在sql server中找到循环依赖表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！