DELETE VAR

delete from mrms.var_kkBondCashflowTemplate where reportid = 1
delete from mrms.var_kkCashFlowMapping where reportid = 1
delete from mrms.var_kkEMWACorrFX where reportid = 1
delete from mrms.var_kkEMWACorrGlobalBond where reportid = 1
delete from mrms.var_kkEMWACorrIDRBond where reportid = 1
delete from mrms.var_kkTotalCalculation where reportid = 1
delete from mrms.var_kkTotalFXVAR where reportid = 1
delete from mrms.var_kkTotalInterestRate where reportid = 1
delete from mrms.var_kkUndiversifiedBond where reportid = 1
delete from mrms.var_kkUndiversifiedFX where reportid = 1
delete from mrms.var_kkVolatilityCalculationBond where reportid = 1
delete from mrms.var_kkVolatilityCalculationFX where reportid = 1
delete from mrms.var_kkYieldAndVolatilities where reportid = 1
delete from mrms.var_report where id = 1