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

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 Received on Tue Jun 27 1995 - 00:00:00 CEST