Re: How to change column names?

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 22 Sep 1998 04:12:12 GMT
Message-ID: <36092338.15197680@netnews.worldnet.att.net>

On Tue, 22 Sep 1998 01:06:39 GMT,
badstreetboy_at_my-dejanews.com wrote:

>I know 'alter table' can add column or change datatype of a column. But can
>it change column name?

Unfortunately, it cannot. The easiest thing to do is to simply add a new column with the name you want, move the data from the old column to the new column, and remove any constraints on the old column. To really get rid of it, you must drop and recreate the table--not fun.

regards,

Jonathan Received on Mon Sep 21 1998 - 23:12:12 CDT