Unique Key Syntax

[rotem_fo]

Hi,
use:
ALTER TABLE
ADD CONSTRAINT
UNIQUE ();

example:
ALTER TABLE EMP ADD CONSTRAINT EMP_NO_UNQ UNIQUE (EMPNO);

Cheers,
R.