About all you can do is make a new table with the structure
you want and use insert into to copy the data and then alter
table to rename the tables in place. (One note though, if
you're trying to go from int2 to int8 it's kind of unhappy
for one step, you'll need to promote to int4 and then to int8
in the select).
Stephan Szabo
sszabo@bigpanda.com
On Tue, 14 Nov 2000, [iso-8859-1] Micka�l Jouanne wrote:
> Hello !
>
> I have a table with :
>
> prixandern | smallint |
> prixcvdern | smallint |
>
> but i want to change smallint to bigint without droping the table.
>
> How can i make that ?