Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Primary key

Re: Primary key

From: daniele stefanucci <d.stefanucci_at_edisontel.it>
Date: Wed, 19 Sep 2001 12:41:58 +0200
Message-ID: <PG_p7.3047$Wg4.13236024@news.edisontel.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US