create table CollegeInformation(CollegeId char(4) primary key);
create table SpecialitiesInformation(SpecialitiesId char(4) primary key);
--
create table StudentInformation(
StudentId char(8) primary key,
Name varchar(10) not null,
Gender char check(Gender in ( '男','女')),
Birthday datetime,
Age int,
Tel int,
CollegeId char(4)foreign key(CollegeId) references
CollegeInformation(CollegeId),
SpecialitiesId char(4)foreign key(SpecialitiesId)
references SpecialitiesInformation(SpecialitiesId),
Class CHAR(2),
IdentityId int,
constraint ck_Birthday check(Age=getdate()-Birthday),
Address varchar(20)
);
如果是这样的约束,不如直接写成计算字段。