---
# System prepended metadata

title: '**#sql server 判斷資料庫table與table關聯性**'

---

# **#sql server 判斷資料庫table與table關聯性**
--.使用工具 ssms
 版本號碼：18.xx.x
 
 三種方式判斷斷資料庫table與table關聯性
 
- **1.GUI操作**
  
  ![](https://i.imgur.com/PdlWgOF.jpg)

  ![](https://i.imgur.com/ZiIZGpb.jpg)
  

- **2.指令**
  
  SELECT   
    f.name AS foreign_key_name  
   ,OBJECT_NAME(f.parent_object_id) AS table_name  
   ,COL_NAME(fc.parent_object_id, fc.parent_column_id) AS constraint_column_name  
   ,OBJECT_NAME (f.referenced_object_id) AS referenced_object  
   ,COL_NAME(fc.referenced_object_id, fc.referenced_column_id) AS referenced_column_name  
   ,is_disabled  
   ,delete_referential_action_desc  
   ,update_referential_action_desc  
FROM sys.foreign_keys AS f  
INNER JOIN sys.foreign_key_columns AS fc   
   ON f.object_id = fc.constraint_object_id   
WHERE f.parent_object_id = OBJECT_ID('[輸入要查table名稱]');
如下圖:
![](https://i.imgur.com/WbPrflg.jpg)

- **3.GUI操作**

![](https://i.imgur.com/hE32vQm.jpg)
![](https://i.imgur.com/ewNb2rG.jpg)
![](https://i.imgur.com/0sIo256.jpg)



