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 vote291 views1 answer
The package java.sql is not accessible
SQL
0 vote134 views1 answer
Oracle running queries sql
SQL
0 vote128 views1 answer
Codeigniter dbforge add index
SQL
20 votes118 views2 answers
Counting in sql
SQL
1 vote166 views1 answer
Ora-01950 no privileges on tablespace
SQL
17 votes129 views6 answers
Change column name in sql
SQL
0 vote90 views1 answer
Expose db in virtualbox
SQL
0 vote124 views1 answer
Select only one row sql
SQL
0 vote132 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
0 vote129 views2 answers
Disallowed function mysql to_date()
SQL