Re: Primary key

sorry....

alter table table_name add (constraint constraint_name primary key (column_name list));

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:44:02 CDT