SQL Server

Выводит все таблицы у которых поле @ColumnNameFind является FK на основную таблицу

DECLARE @ColumnNameFind VARCHAR(250) = 'myColumnName'
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  
   ,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 fc   
   ON f.object_id = fc.constraint_object_id   
--WHERE f.parent_object_id = OBJECT_ID(@ColumnNameFind);
WHERE f.referenced_object_id = OBJECT_ID(@ColumnNameFind)
order by table_name