?????????????÷???
???????????? ???????[ 2016/7/13 11:33:46 ] ????????????? ???
??????????
????—-??????? (Primay Key Constraint) ?? ????????
????—-??? (Unique Constraint) ???????????????????
????—-?????? (Check Constraint)) ???????????Χ???????????(?磺????????)
????—-?????? (Default Constraint) ???????????
????—-?????? (Foreign Key Constraint) ????????????????????????????
?????????????????
????—-??????????????stuNo?????????
????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)
????alter table stuInfo
????add constraint CK_stuSex check (stuSex=’??’ or stuSex=’?′)
????—-????????? (????stuInfo????stuMarks????????????????stuNo)
??????
???·???
??????????????????
2023/3/23 14:23:39???д?ò??????????
2023/3/22 16:17:39????????????????????Щ??
2022/6/14 16:14:27??????????????????????????
2021/10/18 15:37:44???????????????
2021/9/17 15:19:29???·???????·
2021/9/14 15:42:25?????????????
2021/5/28 17:25:47??????APP??????????
2021/5/8 17:01:11