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

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.

P.S.
You may get answers that say yes because it is possible to screw with the internals and change column names. Do not do this!

Michael Hejtmanek // Switzerland // Earth // mhejtmanek_at_clients.switch.ch Received on Sun Jun 25 1995 - 00:00:00 CEST