Re: Renaming a Column

From: adil <aadil_at_loveable.com>
Date: 17 Jul 2001 22:47:48 -0700
Message-ID: <2f4ab398.0107172147.bb1d86@posting.google.com>

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 - 00:47:48 CDT