How to Find Foreign key References in SQL Server

In this post, I provide you one script to find all foreign key sources and destination references in SQL Server.
This script is very useful to all Database Designer and DBA.

Anvesh Patel

Leave a Reply

7 Comments on "How to Find Foreign key References in SQL Server"

Notify of
avatar
Sort by:   newest | oldest | most voted
Candace Thompson
Guest

thanks so much this helped!!!

Boui
Guest

Very interesting points you have observed, appreciate it for putting up. “Strength does not come from physical capacity. It comes from an indomitable will.” by Mohandas Karamchand Gandhi.

Chris Bell
Guest

Very helpful! Thanks for writing this up in your blog.

Soumitra
Guest

This is a good post. I need one more thing. I need to drop all the foreign key in a particular table. reason is to make data only refresh. So can you guide me the process to execute all foreign key drop and re-recreate in one go. It will be a great help.

trackback

very good sir! we are following you…..

wpDiscuz