I’ve seen tables that are referenced by many other tables in the databases and that number was usually around some couple of foreign keys and up to 20, 30 and similar.
Working on a bug, I met an odd table with too many foreign keys. The table is referenced by 327 other tables. Here is a print screen of the query that was run and extracted the results.
So You, please run the next query and please drop me a screen shot on firstname.lastname@example.org if you come up with something extraordinary like this.
obj.name AS [FK NAME],
sch.name AS [schema name],
t1.name AS [referencing table],
c1.name AS [referencing column],
t2.name AS [referenced table],
c2.name AS [referenced column]
FROM sys.foreign_key_columns fkc
INNER JOIN sys.objects obj
ON obj.object_id = fkc.constraint_object_id
INNER JOIN sys.tables t1
ON t1.object_id = fkc.parent_object_id
INNER JOIN sys.schemas sch
ON t1.schema_id = sch.schema_id
INNER JOIN sys.columns c1
ON c1.column_id = parent_column_id
AND c1.object_id = t1.object_id
INNER JOIN sys.tables t2
ON t2.object_id = fkc.referenced_object_id
INNER JOIN sys.columns c2
ON c2.column_id = referenced_column_id
AND c2.object_id = t2.object_id
WHERE t2.name = 'you table name'
AND SCHEMA_NAME(t2.schema_id) = 'table schema'