Re: Change columns datatype and order

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 27 Jun 2005 08:56:52 -0700
Message-ID: <1119887811.994283.24970@g43g2000cwa.googlegroups.com>

Ach C via DBMonster.com wrote:
> Hi all,
> In fact I have two questions! :D
> 1.How to change a columns data type without making that column empty?
> 2.How to change the order of columns in a table?
> for the 2nd one,I know I can create a new table and do "select into" and...
> but I am curious about another way! ;)

As Daniel mentioned, I don't see any purpose to change the column order of a table other then to sync it with a *poorly* written insert statement that does not have the column clause e.g.

insert into this_table values (val1, val2, val3); instead of the proper way
insert into this_table (col1, col2, col3) values (val1, val2, val3);

Regards
/Rauf Received on Mon Jun 27 2005 - 10:56:52 CDT