Subject | Changing numeric domain precision and scale |
---|---|
Author | Erick Sasse |
Post date | 2007-03-08T14:07:27Z |
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
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