Hi,

Whats the difference between a unique constraint and a unique index

For example the following command

ALTER TABLE Company_lkp ADD( CONSTRAINT Company_lkp_Ticker_UNIQUE UNIQUE (Ticker) );

or

Create unique Index Company_lkp_Ticker_UNIQUE on Company_lkp (Ticker);

How are the above 2 statements different?

Thanks