Re: modify datatype with data?

> I had thought of that. Unfortunately I want to change the datatypes of my
> primary keys...

Add another column of the new type, copy the old column to the new one, drop the primary key constraint, declare the new column as primary key and drop the old column.

Regards,

Knut

-- 
Dipl.-Inform. Knut Talman                       Fon +49.30.72 62 01 411
myToys.de GmbH                                  Fax +49.30.72 62 01 222
Schoenhauser Allee 36-39                        Mobil +49.173.671 65 65
D-10435 Berlin