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 vote171 views3 answers
Sql delete all except
SQL
19 votes196 views6 answers
Create table sqlite
SQL
21 votes191 views3 answers
Sql server search column name in all tables
SQL
10 votes183 views2 answers
Mysql drop database if exists
SQL
0 vote175 views4 answers
Stored procedure sql
SQL
0 vote175 views2 answers
How to combine diff colmun value using group by postgres
SQL
0 vote176 views1 answer
What is between keyword used for
SQL
0 vote175 views3 answers
Mysql delete if not in another table
SQL
8 votes170 views1 answer
Insert a select statement into a table
SQL
17 votes179 views6 answers
Get last record in sql
SQL