Modify Data Type Loan & Deposito

 avatar
unknown
plain_text
a year ago
1.2 kB
4
Indexable
ALTER TABLE [bsi].[mrms].[irrbb_loanPrepaymentRate]
ALTER COLUMN totalEarlyPrepayment numeric(32,2);

ALTER TABLE [bsi].[mrms].[irrbb_loanPrepaymentRate]
ALTER COLUMN totalOutstanding numeric(32,2);

ALTER TABLE [bsi].[mrms].[irrbb_simulation_loanPrepaymentRate]
ALTER COLUMN totalEarlyPrepayment numeric(32,2);

ALTER TABLE [bsi].[mrms].[irrbb_simulation_loanPrepaymentRate]
ALTER COLUMN totalOutstanding numeric(32,2);

ALTER TABLE [bsi].[mrms].[LoanPrepaymentRateEquation]
ALTER COLUMN totalEarlyPrepayment numeric(32,2);

ALTER TABLE [bsi].[mrms].[LoanPrepaymentRateEquation]
ALTER COLUMN totalOutstanding numeric(32,2);


ALTER TABLE [bsi].[mrms].[DepositoRedemptionRateEquation]
ALTER COLUMN balance numeric(32,2);

ALTER TABLE [bsi].[mrms].[DepositoRedemptionRateEquation]
ALTER COLUMN ew numeric(32,2);

ALTER TABLE [bsi].[mrms].[irrbb_depositoRedemptionRate]
ALTER COLUMN balance numeric(32,2);

ALTER TABLE [bsi].[mrms].[irrbb_depositoRedemptionRate]
ALTER COLUMN ew numeric(32,2);

ALTER TABLE [bsi].[mrms].[irrbb_simulation_depositoRedemptionRate]
ALTER COLUMN balance numeric(32,2);

ALTER TABLE [bsi].[mrms].[irrbb_simulation_depositoRedemptionRate]
ALTER COLUMN ew numeric(32,2);
Leave a Comment