主キーと外部キーの追加

• Oracle

create table tab10(col1 int,col2 int);
create table tab11(col1 int,col2 int);

alter table tab10 add constraint tab10pk primary key(col1);
alter table tab11 add constraint tab11pk primary key(col1);

alter table tab11 add constraint tab11fk foreign key(col2) references tab10(col1);

insert into tab10 values(1,10);
insert into tab10 values(2,10);
insert into tab10 values(3,20);

insert into tab11 values(51,1);
insert into tab11 values(52,2);
insert into tab11 values(53,3);
insert into tab11 values(54,4);

• MySQL

create table tab10(col1 int,col2 int);
create table tab11(col1 int,col2 int);

alter table tab10 add constraint tab10pk primary key(col1);
alter table tab11 add constraint tab11pk primary key(col1);

alter table tab11 add constraint tab11fk foreign key(col2) references tab10(col1);

insert into tab10 values(1,10);
insert into tab10 values(2,10);
insert into tab10 values(3,20);

insert into tab11 values(51,1);
insert into tab11 values(52,2);
insert into tab11 values(53,3);
insert into tab11 values(54,4);

• PostgreSQL

create table tab10(col1 int,col2 int);
create table tab11(col1 int,col2 int);

alter table tab10 add constraint tab10pk primary key(col1);
alter table tab11 add constraint tab11pk primary key(col1);

alter table tab11 add constraint tab11fk foreign key(col2) references tab10(col1);

insert into tab10 values(1,10);
insert into tab10 values(2,10);
insert into tab10 values(3,20);

insert into tab11 values(51,1);
insert into tab11 values(52,2);
insert into tab11 values(53,3);
insert into tab11 values(54,4);

• SQL Server

drop table tab10;
drop table tab11;

create table tab10(col1 int not null,col2 int);
create table tab11(col1 int not null,col2 int);

alter table tab10 add constraint tab10pk primary key(col1);
alter table tab11 add constraint tab11pk primary key(col1);

alter table tab11 add constraint tab11fk foreign key(col2) references tab10(col1);

insert into tab10 values(1,10);
insert into tab10 values(2,10);
insert into tab10 values(3,20);

insert into tab11 values(51,1);
insert into tab11 values(52,2);
insert into tab11 values(53,3);
insert into tab11 values(54,4);