Find Foriegn Keys and their details in a database

The script will show the details of all the FKs in a particular database. Open SSMS and run the script for the intended database. In the script I have used Adventureworks2012 as an example. You can replace that with your required DB name