Re: rename colunm

It is impossible...

So, If you want to rename it,

1. rename current table to some name
2. create table (use renamed column)
3. Insert renamed_table select * from old_table;

hpcheong_at_ncs.com.sg ÀÌ(°¡) <6t7smp$th4$1_at_nnrp1.dejanews.com> ¸Þ½ÃÁö¿¡¼­ ÀÛ¼ºÇÏ¿´½À´Ï´Ù...
>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
Received on Thu Sep 10 1998 - 03:00:19 CDT