Re: Changing Column Names

From: Rock <grkpetra_at_yahoo.com>
Date: Thu, 14 Oct 1999 21:43:48 -0700
Message-ID: <7u6be7$men$1@ash.prod.itd.earthlink.net>

You can, or will be able to do it, either the current release or the next release of 8i, but from what I've read, it is not as simple as a DROP COLUMN command. I went to a seminar back in May and this was demonstrated. It involves issuing a DROP COLUMN command and then you have to issue another command to compress the table because the DROP COLUMN command does not release the resources that the column was using. Sorry, I don't know the exact syntax off hand...it is at the office...but I thought you'd like to know that it is possible in 8i. Hope this helps.

Rock Lambros
Programmer
Las Vegas Valley Water District

Craig Despres <csdespres_at_callsynergy.com> wrote in message news:kkvN3.8830$pL5.10956_at_news.rdc1.az.home.com...
> Is there any way to rename a column in an existing table without dropping
it
> and adding it back into the table with the correct name?
>
> --
> Craig Despres
> Synergy Solutions Inc.
>
>
Received on Thu Oct 14 1999 - 23:43:48 CDT