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.

Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

If you like this post, then please share it with others.
Please follow, I will share my experience towards the success of Database Research and Development Activity.

I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.

More from

Leave a Reply

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

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

thanks so much this helped!!!


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

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


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.


very good sir! we are following you…..