LearnItFirst User Forum

/*
    Author: Scott Whigham from http://www.LearnSqlServer.com/

    Description: This script tells you the number of foreign keys per table for SQL Server
   
    Versions: SQL Server 2005
   
    Creation Date: September 5, 2006

    For more scripts like this one, visit http://forums.learnsqlserver.com/codesamples.aspx
*/

SELECT SCHEMA_NAME(t.schema_id) + '.' + t.Name AS TableName
    , COUNT(tc.TABLE_NAME) AS NumberOfFKs
FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS AS tc RIGHT JOIN sys.tables t
    ON TABLE_NAME = t.name
    AND tc.CONSTRAINT_TYPE = 'FOREIGN KEY'
WHERE t.is_ms_shipped = 0
GROUP BY SCHEMA_NAME(t.schema_id) + '.' + t.Name
ORDER BY NumberOfFKs