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

3 votes184 views2 answers
Postgres show table schema
SQL
0 vote185 views1 answer
Sqlplus change user
SQL
0 vote199 views1 answer
Query to remove duplicate rows from a table
SQL
15 votes184 views2 answers
Select where duplicate mysql
SQL
58 votes555 views4 answers
Mysql drop column
SQL
0 vote177 views2 answers
How to tun mysql on ubunto
SQL
0 vote177 views1 answer
Mysql earlier than date
SQL
0 vote184 views1 answer
If column value is null then in mysql
SQL
2 votes228 views3 answers
Sql server reseed identity column
SQL
0 vote193 views1 answer
Sql select all records from all tables where not empty
SQL