A foreign key (FK) is a column or combination of columns that is used to establish and enforce a link between the data in two tables to control the data that can be stored in the foreign key table. In a foreign key reference, a link is created between two tables when the column or columns that hold the primary key value for one table are referenced by the column or columns in another table. This column becomes a foreign key in the second table.
What is a FOREIGN KEY ?
- Thread starter chinmay.sahoo
- Start date
mahisharma2
New member
Yes it is group of columns in which data of one column is related to another column data.
Thoughtgrid
New member
The foreign key is column in the relational database provide link between data into two tables it act as cross reference between tables because it reference the primary key in another table.
In the context of relational databases, a foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table.[1][2][3] In simpler words, the foreign key is defined in a second table, but it refers to the primary key in the first table. For example, a table called Employee has a primary key called employee_id. Another table called Employee Details has a foreign key which references employee_id in order to uniquely identify the relationship between both the tables.
SD Group Kolkata
New member
A foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table.
aditiaggarwal
New member
In the context of relational databases, a foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table. In simpler words, the foreign key is defined in a second table, but it refers to the primary key in the first table.
In the context of relational databases, a foreign key is a field (or columns or collection of fields) in one table that uniquely identifies a row of another table. In simpler words, the foreign key is defined in a second table, but it refers to the primary key in the first table.
You may have many FK in your complex databases
You may have many FK in your complex databases
Last edited:
Krishnabangla
New member
A foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table.
Patrick Ferris
New member
In the context of relational databases, a foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table or the same table. In simpler words, the foreign key is defined in a second table, but it refers to the primary key in the first table.
aegisinfoways
New member
A foreign key is a column or group of columns in a relational data source desk that provides a web link between data in two platforms.
Michael Amaral
New member
the foreign key is defined in a second table, but it refers to the primary key or a unique key in the first table.
For example, a table called Employee has a primary key called employee_id. Another table called Employee Details has a foreign key which references employee_id in order to uniquely identify the relationship between both tables.
For example, a table called Employee has a primary key called employee_id. Another table called Employee Details has a foreign key which references employee_id in order to uniquely identify the relationship between both tables.
adlersmith
New member
A foreign key is a column or group of columns in a relational data source desk that provides a web link between data in two platforms.
touchstone
New member
Foreign key consist the primary key and unique key
alberto-morrison
New member
A foreign key is a column or group of columns in a relational database table that provides a link between data in two tables. It acts as a cross-reference between tables because it references the primary key of another table, thereby establishing a link between them.
woodtechkitchens
New member
I agree with you