Re: How to rename a column name?

From: Doug Cowles <dcowles_at_nospambigfoot.com>
Date: Mon, 13 Sep 1999 14:06:48 -0400
Message-ID: <37DD3D38.E40ABD2B@nospambigfoot.com>

Actually, there is no rename column, what you have now in 8i is a drop column, so you
can drop and add for example.

Bob Fazio wrote:

> I believe that you can in Oracle 8.1, but not in earlier versions. It is
> possible in earlier versions, but not through any means that is supported by
> oracle.
> <wy3141_at_my-deja.com> wrote in message news:7rimke$e4a$1_at_nnrp1.deja.com...
> > I want to change the column name,and I don't want to drop it and
> > recreate it. Because it has some dependencies(role right,constraints)
> > on it.
> > Can Oracle support change the column name directly?
> > Any suggestion are helpful.
> > Thanks in advance.
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.

Received on Mon Sep 13 1999 - 13:06:48 CDT