Query To Display The Foreign Key Columns In specific Database

hello Frds,

To Gain the better Performance of Sql Server.Generally we Go for the data to be Normalized means that splitting up the tables into several tables with some specific rules like primary key and foreign key references.

To find out the Foreign key relationships in between the tables of a database

Open the QueryEditor

---> use [database]

Go

select * from sys.foreign_key_columns