SELECT t.name AS table_name
     , i.rows
     , COL_NAME(fc.parent_object_id,fc.parent_column_id) AS ColumnName
     , OBJECT_NAME (f.referenced_object_id) AS ReferenceTableName
     , COL_NAME(fc.referenced_object_id,fc.referenced_column_id) AS ReferenceColumnName
FROM sys.tables AS t
INNER JOIN sys.sysindexes i on (t.object_id = i.id and i.indid < 2)
INNER JOIN sys.foreign_keys f on f.parent_object_id = t.object_id
INNER JOIN sys.foreign_key_columns AS fc ON f.OBJECT_ID = fc.constraint_object_id

WHERE 1 = 1
  and OBJECT_NAME (f.referenced_object_id) = 'Plans'
  and rows > 0
ORDER BY table_name;

select
	fk.Name			fkName,

	parent.Name		tblName,
	fkcc.Name		colName,
	fkc.constraint_column_id,

	reference.Name	refTable,
	refCol.Name		refColumn,

	case delete_referential_action
		when 0 then N'NO ACTION'
		when 1 then N'CASCADE'
		when 2 then N'SET NULL'
		when 3 then N'SET DEFAULT'
		else N'<Unknown>'
		end,

	case update_referential_action
		when 0 then N'NO ACTION'
		when 1 then N'CASCADE'
		when 2 then N'SET NULL'
		when 3 then N'SET DEFAULT'
		else N'<Unknown>'
		end,

	fk.is_not_for_replication,

	fk.is_disabled
from
	sys.foreign_keys fk
inner join
	sys.foreign_key_columns fkc
		on	fkc.constraint_object_id = fk.object_id
inner join
	sys.objects parent
		on	fk.parent_object_id = parent.object_id
inner join
	sys.columns fkcc
		on	fkcc.object_id = parent.object_id
		and	fkcc.column_id = fkc.parent_column_id

inner join
	sys.objects reference
		on	reference.object_id = fk.referenced_object_id

inner join
	sys.columns refCol
		on	refCol.object_id = reference.object_id
		and	refCol.column_id = fkc.referenced_column_id
where
	reference.Name = 'Plans'
order by 
	parent.Name,
	fk.Name,
	fkc.constraint_column_id