Home » SQL & PL/SQL » SQL & PL/SQL » Rename an table
Rename an table [message #239123] Mon, 21 May 2007 09:19 Go to next message
oradat
Messages: 18
Registered: April 2007
Junior Member
Hello every one
how can we rename an table .
Re: Rename an table [message #239127 is a reply to message #239123] Mon, 21 May 2007 09:33 Go to previous messageGo to next message
compcoder
Messages: 30
Registered: April 2007
Location: Maryland USA
Member
RENAME <oldname> to <newname>;

[Updated on: Mon, 21 May 2007 09:38]

Report message to a moderator

Re: Rename an table [message #239128 is a reply to message #239123] Mon, 21 May 2007 09:33 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
rename <oldtablename> TO <newtablename>;

or
alter table <oldtablename> RENAME TO <newtablename>;


Or you could have searched the board.

MHE
Re: Rename an table [message #239132 is a reply to message #239123] Mon, 21 May 2007 09:38 Go to previous message
tarmenel
Messages: 63
Registered: February 2007
Location: Israel
Member

Try searching
Previous Topic: Loading missing data from one table to another
Next Topic: Sending Mail Attachement
Goto Forum:
  


Current Time: Sat Dec 03 17:59:17 CST 2016

Total time taken to generate the page: 0.06806 seconds