SQL的作業(yè)與答案代碼1：外鍵，select * from ，insert into values
create table YG(
YG_ID int primary key? identity(1,1),
YG_Name? nvarchar(50) unique not null,
YG_Age int check(YG_Age>=18 and YG_Age<=60),
ZHIWEI_ID int,
YG_gongzi int check (YG_gongzi>2000),
YG_ruzhishijian date default(getdate())
)
create table ZHIWEI(
ZHIWEI_ID? ?int primary key identity(1, 1),
ZHIWEI_Name nvarchar(50) not null unique
)
alter table YG add foreign key (ZHIWEI_ID) references ZHIWEI (zhiwei_id)
select * from YG
select * from ZHIWEI
insert into zhiwei values('老師')
insert into zhiwei values('班主任')
insert into zhiwei values('校長(zhǎng)')
標(biāo)簽：
