Re: How to rename a table ?
From: Roger Snowden <rsnowden_at_labinterlink.com>
Date: 1997/01/03
Message-ID: <01bbf98e$51fc92c0$096fc589_at_roger.labinterlink.com>#1/1
Date: 1997/01/03
Message-ID: <01bbf98e$51fc92c0$096fc589_at_roger.labinterlink.com>#1/1
Tony DeFelice <tonyd_at_communique.net> wrote in article
<32CC7AAD.4121_at_communique.net>...
> Atif Ahmad Khan wrote:
> >
> > Is this possible ? Also is this a good solution ? I looked up the
alter
> > table command in the SQL Reference manual and did not find a way to
rename
> > a table.
> > Atif Khan
> > aak2_at_ra.msstate.edu
>
> There is no way to rename a table in Oracle...
Simply incorrect.
The syntax is:
RENAME oldtable TO newtable;
Indexes will also be renamed. Received on Fri Jan 03 1997 - 00:00:00 CET