Re: HELP: changing column width
From: Lawrence James <James.Lawrence_at_epamail.epa.gov>
Date: Tue, 20 Dec 1994 11:14:50 GMT
Message-ID: <James.Lawrence.71.000B3FAB_at_epamail.epa.gov>
Date: Tue, 20 Dec 1994 11:14:50 GMT
Message-ID: <James.Lawrence.71.000B3FAB_at_epamail.epa.gov>
In article <3co0uo$ra8$1_at_mhade.production.compuserve.com> Frank Greene <74200.427_at_CompuServe.COM> writes:
>From: Frank Greene <74200.427_at_CompuServe.COM>
>Subject: Re: HELP: changing column width
>Date: 15 Dec 1994 00:00:24 GMT
>create table temp as
>select * from your_table;
>drop table your_table;
Faster to just rename your table.
>create table your_table
>(new column definitions IN SAME ORDER);
>insert into your_table
>select * from temp;
>drop table temp;
Received on Tue Dec 20 1994 - 12:14:50 CET