Execute the following Microsoft SQL Server T-SQL example script in SSMS Query Editor to list all the foreign key relationships (constraints). Display Foreign Key to Primary Key mappings.

-- SQL Foreign Key - list all Foreign Keys - SQL Server find Foreign Keys - INNER JOIN

-- SQL Server list constraints - SQL information_schema views - Disabled Foreign Key info

USE AdventureWorks2008;

SELECT   fkSchemaName = FK.CONSTRAINT_SCHEMA,

         fkTableName = FK.TABLE_NAME,

         fkColumnName = FK.COLUMN_NAME,

         pkSchemaName = PK.TABLE_SCHEMA,

         pkTableName = PK.TABLE_NAME,

         pkColumnName = PK.COLUMN_NAME,

         isDisabled = CASE

                        WHEN is_disabled = 1 THEN 'DISABLED'

                        ELSE ''

                      END,

         fkName = RC.CONSTRAINT_NAME

FROM     INFORMATION_SCHEMA.REFERENTIAL_CONSTRAINTS RC

         INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE FK

           ON FK.CONSTRAINT_NAME = RC.CONSTRAINT_NAME

         INNER JOIN INFORMATION_SCHEMA.KEY_COLUMN_USAGE PK

           ON PK.CONSTRAINT_NAME = RC.UNIQUE_CONSTRAINT_NAME

         INNER JOIN sys.foreign_keys sfk

           ON sfk.name = RC.CONSTRAINT_NAME

WHERE    FK.ORDINAL_POSITION = PK.ORDINAL_POSITION

ORDER BY fkSchemaName,

         fkTableName,

         fkColumnName

-- Partial results