Subject Changing numeric domain precision and scale
Author Erick Sasse
I want to change a domain NUMERIC(18,4) to NUMERIC(15,2). Is there any
special instructions recommended or just an ALTER DOMAIN will do the
job, converting all my data?

I may have values with more than 2 decimals, so I think the decimals
will be converted and the rest will be fine, right? I don't have
numbers greater than 15 digits.

Is it required/recommended to do a backup/restore after this change?

Thanks!

--
Erick Sasse