Oracle
Create Table T_new as select * from Tab_old
SQL Server
Select * into T_new from T_old
表改名
Oracle alter table t rename to T_IdName SQL Server sp_rename ‘T‘ ,‘T_IdName‘
数据库改名
exec sp_renamedb ‘hrmsysdb‘,‘hrmsys‘
原文：http://www.cnblogs.com/yacob/p/3755192.html