Re: RENAME COLUMN

Careful - you cannot just delete (drop) a column. Just create a view or a new table with :

create table newtable as
  (select oldtable.*, oldtable.oldcolumn as newcolumn from oldtable)

then rename the old table with ALTER TABLE, the new table to the required name and recreate your constraints, indexes, views....

On Thu, 22 Feb 2001 21:41:41 +0000, Matthias Rechenburg <rechenburger_at_netcologne.de> wrote:

>Pascal Giansily wrote:
>>
>> How can i rename column name?????
>> Thanks...
>
>hi and sorry,
>
>the only way for renaming a column is to delete it first and
>then create it new.
>
>greetings M. Rechenburg
>
>--
>E-mail :rechenburger_at_netcologne.de
>wap :http://wap.waplocater.de
>www :http://www.waplocater.de
>kostenlose WAP-Seiten bei der Suchmaschine WAPLocater.de

EMail: knijff_at_bigfoot.com Received on Sat Feb 24 2001 - 01:33:25 CST