Εύρεση ενός FK σε όλα τα Tables

find_all_fks_on_a_table.sql

SELECT
    OBJECT_NAME(f.parent_object_id) TableName,
    COL_NAME(fc.parent_object_id, fc.parent_column_id) ColName
FROM sys.foreign_keys AS f
INNER JOIN sys.foreign_key_columns AS fc
    ON f.OBJECT_ID = fc.constraint_object_id
INNER JOIN sys.tables t
    ON t.OBJECT_ID = fc.referenced_object_id
WHERE COL_NAME(fc.parent_object_id, fc.parent_column_id) = 'HEPRLSID'
ORDER BY OBJECT_NAME(f.parent_object_id)