create database kkk
go
use kkk
主表:
create table s
(供应商号 varchar(90) primary key,
供应商名 varchar(90),
所在城市 varchar(90))
从表:
Create table p
(零件号 int primary key,
颜色 varchar(20),
供应商号 varchar(90),
foreign key (供应商号) references s(供应商号) )
insert into s values('B01','红星','北京')
insert into s values('S10','宇宙','上海')
insert into s values('T20','黎明','天津')
insert into s values('Z01','立新','重庆')
insert into p values(010,'红','B01')
insert into p values(312,'白','S10')
insert into p values(201,'蓝','T20')
insert into p values(37,'绿',null)
insert into p values(null,'黄','T20')
insert into p values(201,'红','T20')
insert into p values(105,'蓝','B01')
insert into p values(101,'黄','T11')
select * from s
select * from p
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21173334/viewspace-605342/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/21173334/viewspace-605342/