Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

rename table

Status
Not open for further replies.

ddrillich

Technical User
Jun 11, 2003
546
US
Good Day,

The following two commands are syntactically correct in Oracle:

alter table tst
rename to tst2;

rename tst2 to tst3;

However, based on the following validator, they don't seem to be SQL-99 compliant.
Does anybody know what the proper SQL-99 command to rename a table is?

Thanks,
Dan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top