Re: RENAME COLUMN

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Sat, 27 Feb 1999 16:39:39 +0800
Message-ID: <36D7AF4B.79DB@bhp.com.au>

RL wrote:
>
> Hi everybody!
>
> What's the easy way for rename a column in a table ?
>
> Thank's

1. rename table "xxx" to "xxx_old"
2. create view xxx ( ... ) as select * from xxx_old

where ... contains the new column name that you want

--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"Never wrestle a pig - you both get dirty and the pig likes it..." Received on Sat Feb 27 1999 - 02:39:39 CST