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