UNIQUE

This is a column integrity constraint.
Do not get this confused with the PRIMARY KEY constraint
There are important differences:
UNIQUE can exist with or without the PRIMARY KEY
UNIQUE does not automatically imply NOT NULL
UNIQUE can be applied to several columns in the same table

CREATE TABLE MyProducts 
( 
CONSTRAINT constraint_name ProductID INTEGER UNIQUE (ProductID) 

In SQL Server a unique index is created automatically