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 vote303 views1 answer
IS THEre any difference between using default and := in plsql
SQL
1 vote312 views2 answers
Last working day in week date function in sql
SQL
11 votes348 views2 answers
Oracle source code
SQL
1 vote333 views3 answers
Rows, INSERT INTO
SQL
0 vote333 views1 answer
Generate random & unique mysql string
SQL
3 votes309 views1 answer
Oracle user quota on tablespace
SQL
0 vote291 views1 answer
Declaring variables in pl sql
SQL
-1 vote284 views2 answers
Sql server date format yyyy-MM-ddThh:mm:ss
SQL
0 vote299 views1 answer
Char varchar nvarchar sql
SQL
3 votes342 views3 answers
Mysql declare variable
SQL