Re: How to change column names?

From: <aaronurbain_at_bigfoot.com>
Date: 1998/09/25
Message-ID: <6ueof2$ge4$1@nnrp1.dejanews.com>#1/1

In article <6u6t6v$a2b$1_at_nnrp1.dejanews.com>, badstreetboy_at_my-dejanews.com wrote:
> I know 'alter table' can add column or change datatype of a column. But can
> it change column name?
>
> Thanks..
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

no. rename the table, create the table with the new name, and insert(select). dont forget your constraints, grants and triggers.

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Sep 25 1998 - 00:00:00 CDT