Plan Your Foreign Keys. Source code -- Check it SELECT name is_disabled is_not_trusted FROM sys. In simple words you can say that a foreign key in one table used to point primary key in another table.
What is a Foreign Key. Lets take a look at the following customers and orders tables from the sample database. Foreign_keys WHERE name FK_Person_BusinessEntity_BusinessEntityID.
This is the way how we relate data stored in different tables in our database model.
In a foreign table column which is foreign key reference a column of another table. This is the way how we relate data stored in different tables in our database model. I STUDENT relation Student_NO in Student_COURSE is a foreign key to Student_NO. Foreign keys ensure data integrity eg.