September 4, 2007 - SQL Authority with Pinal Dave

SQL SERVER – 2005 – Find Tables With Primary Key Constraint in Database

September 4, 2007

SQL Constraint and Keys, SQL Scripts, SQL System Table

My article SQL SERVER – 2005 Find Table without Clustered Index – Find Table with no Primary Key has received following question many times. I have deleted similar questions and kept only latest comment there. In SQL Server 2005 How to Find Tables With Primary Key Constraint in Database? Script…

SQL SERVER – 2005 – Find Tables With Foreign Key Constraint in Database

September 4, 2007

Pinal Dave

SQL Tips and Tricks

SQL Constraint and Keys, SQL Scripts, SQL Server, SQL System Table

While writing article based on my SQL SERVER – 2005 Find Table without Clustered Index – Find Table with no Primary Key I got an idea about writing this article. I was thinking if you can find primary key for any table in the database, you can sure find foreign key for any table in the database as well.