Re: rename colunm

hpcheong_at_ncs.com.sg wrote:
>
> hi all,
>
> i am trying to rename a colunm name from sch to school,
>
> note: there's data in this field and i want to retain the data
>
> what is the syntax to do it
>
> thanks in advance!
>
> rgds,
> evelyn.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum

Option 1: Unload data / drop table / recreate / reload

Option 2: Put a view on top the table and use that

Option 3: Some people may recommend hacking the SYS.COL$ but that wouldn't be me....

Have fun

-- 
==========================================
Connor McDonald
BHP Information Technology
Perth, Western Australia
"These views mine not BHP..etc etc"

"The only difference between me and a madman is that I am not mad."