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

3 votes132 views1 answer
Oracle apex warning message
SQL
1 vote125 views1 answer
Ilike for date postgres
SQL
0 vote132 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
1 vote129 views1 answer
Mysql server does not start mac
SQL
0 vote126 views1 answer
Use where instead of join
SQL
0 vote120 views1 answer
How change the field place in mysql
SQL
1 vote132 views1 answer
Sqlite check if row exists
SQL
10 votes148 views1 answer
How to import database in mysql by cmd
SQL
0 vote189 views1 answer
Sqlite schema structure of a relational database
SQL
0 vote133 views1 answer
Postgres meta command to show all rows in table
SQL