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
This site works best with JavaScript enabled