SQL Server ->> 查找某表的主键被哪些表外检引用

查找某表的主键被哪些表外检引用

  SELECT B.NAME,C.NAME,*
  FROM SYS.foreign_key_columns A
  JOIN SYS.objects B ON A.referenced_object_id = B.object_id
  JOIN SYS.objects C ON A.parent_object_id = C.object_id
  WHERE B.NAME = ''