代码:
alter table Teacher add constraint PK_Teacher_id primary key(Id) if exists(select * from sysobjects where name='UQ_Teacher_Name') alter table teacher drop constraint UQ_Teacher_Name alter table teacher add constraint UQ_Teacher_Name unique(name) alter table teacher add constraint CK_Teacher_Age check(age>0 and age<=100) alter table teacher add constraint DF_Teacher_Birthday default('1990-9-9')for birthday alter table teacher add constraint FK_Teacher_classid foreign key(classId) references classes(cid)