Modify Data Type Loan & Deposito

mail@pastecode.io avatar
unknown
plain_text
2 months ago
1.2 kB
3
Indexable
Never
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