Create two tables with foreign key relation

 create table Emp(Eid int primary key not null, Name varchar(50),Email varchar(50), Salary money)

create table City(CityId int primary key not null, Eid int foreign key references Emp(Eid), CityName varchar(50))

thru video we can add two tables

https://www.youtube.com/watch?v=tuDxbnKPmuo&t=1117s&pp=ygUdc3R1ZGVudCBtYW5hZ2VtZW50IHN5c3RlbSBtdmM%3D