Re: Change/delete column name without drop table?
From: student <defaultuser_at_default.com>
Date: Thu, 11 Feb 1999 13:34:15 -0500
Message-ID: <36C322A7.1B386D7B_at_default.com>
Date: Thu, 11 Feb 1999 13:34:15 -0500
Message-ID: <36C322A7.1B386D7B_at_default.com>
I don't know whether this will work.
You can copy the table into another table by selecting all columns except that one particular column. Change the name of the new table to old table. Delete the old table.
GB
Albert Zhu wrote:
>
> Hi,
>
> Hi,
>
> I am looking for a way in sqlplus to change/delete a column name. The
> ALTER TABLE seems can not do that. And I can not drop the table
> because it is tied to too many other tables.
>
> Any help is very appreciated.
>
> Albert
Received on Thu Feb 11 1999 - 19:34:15 CET