Re: How do I rename a column in a table

Hi

Evetually I foud the answer in the manual. If anyone else should have this problem, here's Oracles example:

CREATE TABLE temporary (newname, col2, col3) AS SELECT oldname, col2, col3 FROM static DROP TABLE static
RENAME temporary TO static

fredrikpwahlgren <fredrik.p.wahlgren_at_mailbox.swipnet.se> skrev i inlägg <01be09e3$edae4580$1ba1f482_at_fredrik.p.wahlgren>...
> Dear fellow developers
>
> Someone at my office asked how to do this. This guy has a table with
> several columns and he wants to rename one of them without having to drop
> the table.
> If yiu know, please respond to me directly.
>
> Regards,
> Fredrik
>
Received on Sun Nov 08 1998 - 21:12:58 CET