您可以尝试以下查询。

SQL语言

SELECT OBJECT_NAME(f.parent_object_id) AS table_name  
    , f.name AS foreign_key_name  
    ,COL_NAME(fkc.parent_object_id, fkc.parent_column_id) AS constraint_column_name  
    ,OBJECT_NAME (f.referenced_object_id) AS referenced_object  
    ,COL_NAME(fkc.referenced_object_id, fkc.referenced_column_id) AS referenced_column_name  
   , [column_type] = t.name
    --,f.is_disabled, f.is_not_trusted
    --,f.delete_referential_action_desc  
    --,f.update_referential_action_desc  
FROM sys.foreign_keys AS f
   INNER JOIN sys.foreign_key_columns AS fkc   
      ON f.object_id = fkc.constraint_object_id
   LEFT JOIN sys.all_columns ac on fkc.referenced_object_id = ac.object_id 
      and fkc.referenced_column_id = ac.column_id
   INNER JOIN sys.types t on ac.system_type_id = t.system_type_id
--WHERE f.parent_object_id = OBJECT_ID('dbo.PropertySegment')
ORDER BY table_name;