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 vote209 views1 answer
Replace string in whole database mysql stackoverflow
SQL
0 vote199 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
0 vote168 views2 answers
Postgresql could not start server mac
SQL
0 vote198 views1 answer
Call function sql oracle
SQL
-2 votes199 views1 answer
Create trigger syntax
SQL
3 votes202 views2 answers
Pl sql escape '
SQL
0 vote212 views1 answer
MySQL update with subquery
SQL
0 vote212 views1 answer
Resullt all update knex mysql
SQL
0 vote221 views1 answer
Postgres dump sql insert
SQL
1 vote195 views1 answer
Loading local data is disabled mysql
SQL