Hello,

i would like to alter the column type which has exist in
the table, i can't find anything about that, can anybody help me?
  

-- 
Best regards,
 anson                          mailto:anson_tsai@sina.com




Wed, 31 Jan 2001 09:54:08 +0800
anson <anson_tsai@sina.com>
alter the column type
> i would like to alter the column type which has exist in
> the table, i can't find anything about that, can anybody help me?

To effectively alter the type of a column, you must do a "create
table"/"insert into"/"create table as" combination to make an
intermediate temporary table with the correct type (of course, other
permutations of commands can give the desired result also).

                     - Thomas

Tue, 06 Feb 2001 04:51:51 +0000
Thomas Lockhart <lockhart@alumni.caltech.edu>
Re: alter the column type