Re: SQL question, updating all rows

hello,
In article <35853E72.541DE74A_at_crv.pechiney.fr>, Zahi Al-Jamous <aljamous_at_crv.pechiney.fr> writes:
> Hello,
>
> I have a table where I added a column, and I want this column to be
> the primary key of my table. I need then to update this column,
> adding a unique value for each row of my table.
> Can someone tell me how i can do this in SQL ?

1. add the column
2. update this column with unique values (e.g. use a sequnece)
3. create the pk constraint

>
> TIA,
>
> Zahi
> --
> Zahi Al-Jamous e-mail: aljamous_at_crv.pechiney.fr
> Groupe GIL
> Pechiney-CRV
> BP 27 tel (work): +33.(0)4.76.57.82.45
> F-38340 Voreppe tel (cell): +33.(0)6.14.55.16.88
HTH
        peter Received on Tue Jun 16 1998 - 00:53:35 CDT