sql\mysql\oralce 表名更改

sql  --     EXEC sp_rename '旧表名','新表名'
EXEC sp_rename 'LIST_DROP_DTL','STK_LIST_DROP_DTL'  
EXEC sp_rename 'TENDER_OFFER_INFO','STK_TENDER_OFFER_INFO' 
EXEC sp_rename 'TENDER_OFFER_DTL','STK_TENDER_OFFER_DTL' 
EXEC sp_rename 'TENDER_OFFER_PRG','STK_TENDER_OFFER_PRG' 
EXEC sp_rename 'ETF_SUBS_INFO','FND_ETF_SUBS_INFO' 
EXEC sp_rename 'STRU_FUND_CALL','FND_STRU_CALL' 


 mysql 


 alter table     LIST_DROP_DTL                rename            STK_LIST_DROP_DTL;
 alter table TENDER_OFFER_INFOrename STK_TENDER_OFFER_INFO; 
 alter table TENDER_OFFER_DTLrename STK_TENDER_OFFER_DTL; 
 alter table TENDER_OFFER_PRGrename STK_TENDER_OFFER_PRG ;
 alter table ETF_SUBS_INFO   rename       FND_ETF_SUBS_INFO; 
 alter table STRU_FUND_CALL   rename       FND_STRU_CALL;


 oracle 
 alter table TENDER_OFFER_INFOrename to STK_TENDER_OFFER_INFO;
 alter table TENDER_OFFER_DTLrename to STK_TENDER_OFFER_DTL;
 alter table TENDER_OFFER_PRGrename to STK_TENDER_OFFER_PRG;
 alter table ETF_SUBS_INFO   rename to FND_ETF_SUBS_INFO;
 alter table STRU_FUND_CALL   rename to FND_STRU_CALL;