OraFAQ Forum: SQL & PL/SQL » Rename an table

Home » SQL & PL/SQL » SQL & PL/SQL » Rename an table

Mon, 21 May 2007 09:19

oradat
Messages: 18
Registered: April 2007

Junior Member

Hello every one
how can we rename an table .

Mon, 21 May 2007 09:33

compcoder
Messages: 30
Registered: April 2007
Location: Maryland USA

Member

RENAME <oldname> to <newname>;

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

Mon, 21 May 2007 09:33

Maaher
Messages: 7065
Registered: December 2001

Senior Member

rename <oldtablename> TO <newtablename>;

alter table <oldtablename> RENAME TO <newtablename>;

Or you could have searched the board.

MHE

Mon, 21 May 2007 09:38

tarmenel
Messages: 63
Registered: February 2007
Location: Israel

Member

Previous Topic:	Loading missing data from one table to another
Next Topic:	Sending Mail Attachement

Goto Forum:

]

Current Time: Mon Dec 09 21:12:31 CST 2024