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_INFO rename STK_TENDER_OFFER_INFO ; 
 alter table TENDER_OFFER_DTL rename STK_TENDER_OFFER_DTL ; 
 alter table TENDER_OFFER_PRG rename 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_INFO rename to STK_TENDER_OFFER_INFO ;
 alter table TENDER_OFFER_DTL rename to STK_TENDER_OFFER_DTL ;
 alter table TENDER_OFFER_PRG rename 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 ;