Re: [Q]: Renaming columns in a table ?

In <DAtF7z.LEJ_at_ainet.com> jfruetel_at_ainet.com (John Fruetel) writes:
>
>MHEJTMANEK_at_clients.switch.ch (MICHAEL HEJTMANEK) wrote:
>
>>In <3skdqh$mtb_at_ixnews4.ix.netcom.com> rsingh_at_ix.netcom.com writes:
 

>>>
>>>
>>> Is is possible to rename a column in a table ?
>>>
>>> Thanks in advance.
>
>
>
>>No. You need t get the data out. Drop the table. Rebuild the table
>>(with new col names) and then put the data back in.
>
>Why can't any of the major databases (Oracle, Sybase) do this? I do
>this routinely on my Watcom databases...
>John Fruetel
>jfruetel_at_ainet.com
>

It's also done routinely in Universe and Pick.

-- 
Chuck Hamilton
chuckh_at_ix.netcom.com

Never share a foxhole with anyone braver than yourself!