Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How do you rename a Table in Oracle

Re: How do you rename a Table in Oracle

From: Alistair Thomson <alistair.thomson_at_spinxcst.co.uk>
Date: Wed, 20 May 1998 11:17:33 +0100
Message-ID: <3562ADBD.10963AA7@spinxcst.co.uk>


Try

 sql> rename oldtablename to newtablename;

ADT Richard J. Jenkins wrote:

> ALTER TABLE OldTableName RENAME TO NewTableName
>
> b/r
>
> Jinx
>
> reb_at_timevest.com wrote:
> >
> > What would be the Oracle equivalent to the sybase command
> >
> > sp_rename "OldTableName", "NewTableName"
> >
> > ?!
Received on Wed May 20 1998 - 05:17:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US