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 vote124 views1 answer
Mysql convert column to uppercase
SQL
0 vote217 views2 answers
How to install psql in ubuntu
SQL
1 vote164 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
1 vote179 views1 answer
Sqlite3 read only
SQL
1 vote184 views1 answer
Oracle convert run duration to number
SQL
4 votes160 views3 answers
Mysql varchar length
SQL
0 vote180 views1 answer
Check if database exists sql
SQL
1 vote181 views1 answer
Blob datatype in mysql
SQL
1 vote191 views1 answer
Spark sql convert string to date
SQL
1 vote172 views3 answers
How to get date in sql
SQL