摘要:
--完整性约束use mydbtestgoalter table infoTadd constraint uni_user_addrunique(UserID)--唯一值--主键约束alter table messageadd constraint px_message--约束名primary key clustered--check约束--创建一列alter table UserManageradd state tinyintselect * from UserManageralter table UserManager--添加约束add constraint Uni_sta check(s 阅读全文