INFORMATION_SCHEMES. Find tabeller/constraints som refererer til tabel

select so1.NAME AS table_name
      ,so2.name AS referencing_table_name
      ,fk.name as constraint_name
from sys.foreign_keys fk
JOIN sys.sysobjects so1 ON (so1.id = fk.referenced_object_id)
JOIN sys.sysobjects so2 ON (so2.id = fk.parent_object_id)
WHERE (so1.name = @1)
  AND (so1.xtype = 'U')
  AND (fk.parent_object_id <> fk.referenced_object_id)

select so1.NAME AS table_name
      ,so2.name AS referencing_table_name
      ,fk.name as constraint_name
from sys.foreign_keys fk
JOIN sys.objects so1 ON (so1.object_id = fk.referenced_object_id)
JOIN sys.objects so2 ON (so2.object_id = fk.parent_object_id)
WHERE (so1.name = @p1)
  AND (fk.parent_object_id <> fk.referenced_object_id)