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 vote334 views2 answers
Plsql regex match whole word
SQL
0 vote308 views1 answer
Change mysql version to 5.7 in ubuntu
SQL
0 vote321 views1 answer
Joins vs includes
SQL
2 votes283 views4 answers
Mysql change database character set to utf8mb4
SQL
0 vote313 views1 answer
How to update rows from a table when certain conditions are met in mysql
SQL
0 vote389 views2 answers
How to check if a column exists in a SQL Server table?
SQL
0 vote331 views2 answers
Demmarrer un service mysql teminal cmd
SQL
2 votes335 views1 answer
Oracle kill session by sql_id
SQL
5 votes362 views1 answer
Mysql add user with all privileges
SQL
2 votes339 views1 answer
Sql OR
SQL