Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to rename a table ?
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 CST
![]() |
![]() |