Create Table TABLENAME

(

ID bigint primary key,

Name varchar(250) Unique Key

)

–Single Unique Key in Table

ALTER TABLE TABLENAME ADD CONSTRAINT
UC_ConstraintName UNIQUE NONCLUSTERED
(
Field1,Field2,Field3
)

–Unique Key Combination in SQL.