Re: diff. between Primary-Key and unique index

A unique index created directly with a "create unique index" command is an old-fashioned way to code integrity constraints.

It exists for compatibility purposes with older versions of Oracle, but it shouldn't be use anymore for new databases.

--
Regards

Emmanuel HUMBLOT e_humblot_at_wanadoo.fr

Andreas Michler <Andreas.Michler_at_adicom.de> a écrit dans l'article <388819AE.547713F0_at_adicom.de>...
> Can anyone tell me the differences between a table with primary key
> and
> a table with no primary key, but a unique index on some fields
> ????????
>
>
>
> -------------------------------------
> ADICOM Informatik GmbH
> Andreas Michler
> Wiesfleckenstr. 34
> 72336 Balingen
> Tel: 07433/9977-57,Fax: -90
> E-Mail: Andreas.Michler_at_adicom.de
> http:\\www.adicom.de
> -------------------------------------
>
>
>
Received on Fri Jan 21 2000 - 03:39:09 CST