Foreign keys

CREATE TABLE Employee(
    EmployeeID int NOT NULL,
    LastName varchar(50) NOT NULL,
    FirstName varchar(20) NOT NULL,
    Age int,
    DeptNo int,
    PRIMARY KEY (EmployeeID),
    FOREIGN KEY (DeptNo) REFERENCES Department(DeptNo)
);

Foreign key

USE Organization
CREATE TABLE Employee_Office
(
Id INT PRIMARY KEY IDENTITY(1,1),
Emp_Id int FOREIGN KEY REFERENCES Employee(Id),
Office_Id int FOREIGN KEY REFERENCES Office(Id)
)

Source: codingsight.com

What is foreign key

Foreign Key: 
It is a column that comes from a different table and
using Foreign key tables are related each other
It is the primary key of another table
It can be duplicate or null for another table

Foreign key

CREATE TABLE Employee(
    EmployeeID int NOT NULL,
    LastName varchar(50) NOT NULL,
    FirstName varchar(20) NOT NULL,
    Age int,
    DeptNo int,
    PRIMARY KEY (EmployeeID),
    FOREIGN KEY (DeptNo) REFERENCES Department(DeptNo)
);

Source: computerscienceai.com

Foreign key

USE Organization
CREATE TABLE Employee
(
Id INT PRIMARY KEY IDENTITY(1,1),
Name VARCHAR (50) NOT NULL,
Age INT,
Gender VARCHAR (50),
Dep_Id int FOREIGN KEY REFERENCES Department(Id),
Insur_Id int FOREIGN KEY REFERENCES Insurance(Id)
)

Source: codingsight.com

Similar codes

0 vote356 views1 answer
Query only first letter string
SQL
16 votes322 views6 answers
Your connection attempt failed for user 'root' to the mysql server at localhost 3306
SQL
1 vote345 views1 answer
How not to sort by average rating
SQL
-1 vote348 views1 answer
Difference berween database and data base management system
SQL
15 votes292 views6 answers
Drop foreign key mysql
SQL
0 vote281 views1 answer
Oracle call a function in a insert statement
SQL
13 votes291 views6 answers
Current date sql
SQL
0 vote269 views1 answer
Postgresql parse json array
SQL
0 vote298 views2 answers
Android sqlite query join
SQL
0 vote291 views1 answer
Remove transient options sql wordpress
SQL