| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Unique Index Vs. Unique Constraints
>
>hi there,
>
>If I already created Unique index for the column, is it necessary to
>create a Unique constraint on it to ensure the value is unique?
>
>Thanks.
>ken.
Hi Ken,
The unique index will ensure that the value is unique. You would only need
to create the unique constraint if you wished to set up a foreign key to this
table from a 'child' table.
HTH,
Rob
Received on Thu Jun 01 2000 - 00:00:00 CDT
 |
 |