sql添加唯一约束

ALTER TABLE UserInfo ADD CONSTRAINT ic_Num UNIQUE NONCLUSTERED(UserICCardNumber)

ALTER TABLE UserInfo ADD CONSTRAINT id_Num UNIQUE NONCLUSTERED(UserIDCardNumber)

原文地址:https://www.cnblogs.com/dodui/p/2200149.html