Hello Dear,
Please Tell Me What Is Foreign key ?
Hello Dear,
Please Tell Me What Is Foreign key ?
(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::
Code:CREATE TABLE Student( Id int NOT NULL PRIMARY KEY, Name int NOT NULL, DepartmentId int FOREIGN KEY REFERENCES Department(Id) )
Last edited by Sherin; 08-21-2019 at 02:39 AM.
Thanks for the great knowledge
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.
Taxi Dispatch Software | Uber Clone Script | Taxi Dispatch System |
Best Taxi Dispatch Software | Readymade Uber Clone App | Uber Clone App | Taxi Dispatch App |
Taxi App Admin Panel |
Gojek Clone App Development |
Limo Dispatch System |
Para Transit Dispatch System |
Car Rental Management system
Gojek Clone Software
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.
|
Bookmarks