Foreign key ?

[joyadelfin]

Hello Dear,

Please Tell Me What Is Foreign key ?

[Sherin]

(1) Foreign Key provides link between data in two tables.
(2) It acts as a cross-reference between tables because it references the primary key of another table, establishing a link between them.

SQL Server::

CREATE TABLE Student(
Id int NOT NULL PRIMARY KEY,
Name int NOT NULL,
DepartmentId int FOREIGN KEY REFERENCES Department(Id) )

[blackmagicislam]

Thanks for the great knowledge

[vigneshtech]

A foreign key is a group of columns in a relational database table which provides a link between data in two tables. Foreign key acts as a cross-reference between tables because it refers to the primary key of another table, thereby to establish a link between them.

[joyadelfin]

Thank's Dear.

[shaili shah]

A foreign key is a key used to link two tables together.it is a column or a combination of columns whose values match a Primary Key in a different table.