Re: How to change column names?

From: Nisar Tareen <ntareen_at_attcanada.net>
Date: 1998/09/23
Message-ID: <BwZN1.693$lb2.7819503@cabot.ops.attcanada.net>#1/1

You can change table name , column datatype but not the column, create a new table name with the desired column name and the get the old data by create new_table_name by select
fill the data.

Nisar Tareen.

badstreetboy_at_my-dejanews.com wrote in message <6u6t6v$a2b$1_at_nnrp1.dejanews.com>...
>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
Received on Wed Sep 23 1998 - 00:00:00 CDT