Re: How to change column names?

From: Murali Krishna <krishnam_at_batelco.com.bh>
Date: 1998/09/24
Message-ID: <6udd79$8s6@sv11.batelco.com.bh>#1/1

I feel that this logic should work:

First insert a column with the same attributes but with the changed column name.

Update this new column with the data from the old column.

Then after the update remove this old column.

This column which is going to be renamed should'nt have any constraints and it should not be the primary key.

If any body feels that this is not the best pls. let me know. badstreetboy_at_my-dejanews.com wrote in message <6u6t6v$a2b$1_at_nnrp1.dejanews.com>...
>I know 'alter table' can add column or change datatype of a column. But
can
>it change column name?
>
>Thanks..
>
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Thu Sep 24 1998 - 00:00:00 CDT