Pinal Dave - SQL Server Performance Tuning Expert

This month's discount Comprehensive Database Performance Health Check Testimonials

Home

SQL SERVER – Query to Display Foreign Key Relationships and Name of the Constraint for Each Table in Database

November 1, 2006

Pinal Dave

SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts, SQL Stored Procedure

A long query on INFORMATION_SCHEMA views that shows foreign key relationships for each table: the table, column, referenced table and the constraint name.