Find Foreign Key Relationships using T-SQL

This is very hard to find T-SQL online and very much handy screen. I have written myself and posted on blog for easy reference. Make sure to bookmark it and save the script on permanent archive.