A FOREIGN KEY is a field or collection of fields in one table that refers to the PRIMARY KEY in another table. The table containing a foreign key is called the Child Table while the table which contains the Primary Key (or the Candidate Key) is known as the Referenced Table or the Parent Table.

Foreign keys are used to enforce referential integrity within our SQL Server database. For better understanding of the concept of foreign keys, we are using a GUI in SQL Server in this video tutorial. We will start with the basics; i.e., how to create a Foreign Key in a child table referencing its parent table.

Understanding Foreign Key Through GUI In SQL Server

13.5k

500

Zia Ahmed Shaikh

Microsoft Certified Professional - v-Blogger - More than a decade of experience of Microsoft tools including Asp.Net, MVC, Entity Framework SQL Server. Love to make video tutorials on various development tools. He holds a Computer Science Master degree from ILMA University. As a technology practitioner, he is always excited by all the new technologies. He believe learning is a lifelong process. He realizes that best way of learning is using and sharing. He thinks hard to see how to use new technologies at work.