Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create table Persons
- (
- PersonID int not null identity,
- FirstName varchar(50) not null,
- Salary decimal(18,2) not null,
- PassportID int not null
- )
- insert into Persons (FirstName, Salary, PassportID)
- values ('Roberto', 43300.00,102), ('Tom', 56100.00, 103), ('Yana', 60200.00, 101)
- alter table Persons
- add primary key(PersonID)
- create table Passports
- (
- PassportID int not null,
- PassportNumber varchar(50) not null
- )
- insert into Passports (PassportID, PassportNumber)
- values (101, 'N34FG21B'), (102, 'K65LO4R7'), (103, 'ZE657QP2')
- alter table Passports
- add primary key(PassportID)
- alter table Persons
- add foreign key(PassportID)
- references Passports(PassportID)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement