--添加主键约束(stuNo作为主键,stuInfo为表名)
alter table stuInfo
add constraint PK_stuNo PRIMARY KEY (stuNo)
--添加唯一约束
alter table stuInfo
add constraint UQ_stuID UNIQUE (stuID)
--添加默认约束(地址不填,默认为地址不详)
alter table stuInfo
add constraint DF_stuAddress DEFAULT ('地址不详') FOR stuAddress
--添加检查约束 要求年龄在15-40岁之间
alter table stuInfo
add constraint CK_stuAge CHECK(stuAge BETWEEN 15 AND 40)
--添加外键约束 (表名stuMarks stuInfo)
alter table stuMarks
add constraint FK_stuNo FOREIGN KEY(stuNo) REFERENCES stuInfo(stuNo)