ALTER TABLE Student --主鍵約束
ADD CONSTRAINT PK_StuNo PRIMARY KEY (StudentNo)
ALTER TABLE Student --唯一約束(身份證號(hào)唯一)
ADD CONSTRAINT UQ_stuID UNIQUE (IdentityCard)
ALTER TABLE Student --默認(rèn)約束(地址不詳)
ADD CONSTRAINT DF_stuAddress DEFAULT ('地址不詳') FOR Address
ALTER TABLE Student --檢查約束(出生日期是自1980年1月1日以后)
ADD CONSTRAINT CK_stuBornDate CHECK(BornDate>='1980-1-1')
ALTER TABLE Student --添加外鍵約束
ADD CONSTRAINT FK_Grade
FOREIGN KEY(GradeID) REFERENCES Grade(GradeID)
go
浙公網(wǎng)安備 33010602011771號(hào)