Re: How to change column names?

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

[Quoted] I feel that this logic should work:

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

[Quoted] Update this new column with the data from the old column.

[Quoted] Then after the update remove this old column.

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

[Quoted] 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 CEST

This message: [ Message body ]
Next message: Walter Stucki: "Re: How to change column names?"
Previous message: gayatribalaji_at_my-dejanews.com: "Re: What are the best materials to use for the OCP?"
In reply to: badstreetboy_at_my-dejanews.com: "How to change column names?"
In reply to a_andy_at_my-dejanews.com: "Tuning : Where clause"
Next in thread: Walter Stucki: "Re: How to change column names?"
Reply: nobody: "Re: How to change column names?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message