Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Primary key
No, it isn't possible to have more than one primary key.
Daniele
"thierry" <thierry.constant2_at_wanadoo.fr> ha scritto nel messaggio
news:3BA86F6C.6AED6A3_at_wanadoo.fr...
> Hi,
>
> - is it possible to have more than one primary key in a table ?
> ( because if i don't know the name of the primary key, I have to use:
> alter table my_table drop primary key cascade and it may be confused
> ....)
>
> - how to add a primary key to an existing table ?
> ( alter table article modify idarticle number primary key doesn't work
> )
>
>
> Thanks for your answers ...
>
>
Received on Wed Sep 19 2001 - 05:41:58 CDT