Re: Changing the name of a column

From: Steve Cosner <stevec_at_zimmer.CSUFresno.EDU>
Date: 1995/04/25
Message-ID: <D7LMKv.4Ao_at_CSUFresno.EDU>#1/1


>>
>>>
>>> Could somebody tell me how I would change the name of a column .
>>> Any help would be appreciated .
>>
>>You cannot do it directly or in one step. you can:
>>
>>1. use sqlplus COPY to create a new table with new column names,
>> then drop the old table and rename the new one; or
>>2. create a view with new column names, and a synonym of the view
>> which has the name of the original table and which yields the view.
>>--
>Or ...
>
>3. Add a new column to the existing table with the new name, use
>sqlplus to populate it, and then drop the old column.
>--

       My SQL Ref. Manual doesn't tell how to drop a column.
       Can you post the command?  I sure could use this feature!
Received on Tue Apr 25 1995 - 00:00:00 CEST

Original text of this message