Create Table T_new as  select * from Tab_old

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‘