What is foreign key in database?

A foreign key is a column or group of columns in a relational database table that provides a link between data in two tables and it acts as a cross reference between tables. Because it references the primary key of another table and thereby establishing a link between them.

  • The foreign shows relationship between two tables.
  • When the primary key is inserted in first table and when the first table connects with the second table in database.
  • Then the relationship shows the link between the two tables in sql server.


Copyright Future Minutes © 2015- 2024 All Rights Reserved.   Terms of Service  |   Privacy Policy |  Contact US|  Pages|  Whats new?
Update on: Dec 20 2023 05:10 PM