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);