UNIQUE definition 

A UNIQUE definition in the CREATE TABLE statement defines the uniqueness of column value combinations.

Syntax

<unique definition> ::= [CONSTRAINT <index name>] UNIQUE (<column name>,...)

index name, column name

Explanation

Specifying a UNIQUE definition in a CREATE TABLE statement has the same effect as specifying the CREATE TABLE statement without a UNIQUE definition, but with a CREATE INDEX statement with UNIQUE.