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 vote305 views1 answer
Having trouble running COUNT in my INSERT INTO statement
SQL
0 vote297 views1 answer
Select from another database
SQL
0 vote297 views1 answer
Sql fetch next 10 rows pdo
SQL
2 votes286 views2 answers
Mysql all columns
SQL
0 vote278 views1 answer
Metada in sql
SQL
0 vote306 views1 answer
Sql server manager close connection
SQL
1 vote292 views1 answer
Index a database column sql
SQL
12 votes305 views1 answer
Script to add new column in table sql
SQL
1 vote339 views1 answer
Sql view where tables have same column name combine results
SQL
0 vote304 views1 answer
Get all jobs if salary more than 5500 less than 10000 sql
SQL