SQL Guide : Using SQL for database administration : Managing indexes : Creating a unique index on a table
  
Creating a unique index on a table
CREATE UNIQUE INDEX index_name ON table_name (column_name);
The following example creates a unique index named UX_TEST on column I of the table TEST.
CREATE UNIQUE INDEX UX_TEST ON TEST (I);
See also
Managing indexes