Re: Renaming a Column

Hi there,

As per my knowledge u dont have option to rename a column i have 2 options with me
I

1. alter table <tablename> add(<newcolname> <datatype>)
2.update tablename set newcolname=oldcolname
3.drop col oldcolname.

II
create table <newtablename>(col1,col2,newcolname,col4)as select * from oldtablename

drop the old table.

Hope this will help U

Regards
Adil Received on Wed Jul 18 2001 - 07:47:48 CEST