创建非主键唯一约束

USE ZrqCommon;
GO
ALTER TABLE UserInfo
ADD CONSTRAINT AK_UserName UNIQUE (UserName);
GO