Subject | Altering a domain |
---|---|
Author | Aldo Caruso |
Post date | 2015-06-16T15:15:41Z |
Hi,
I have defined the following domain :
CREATE DOMAIN CURRENCY AS decimal(9,2)
I would like to alter it as the following :
ALTER DOMAIN CURRENCY AS decimal(18,2)
I have many fields in tables that depend on this domain and they
are filled with values.
Will they be restructured in their internal representation ( from
INTEGER to BIGINT in dialect 3 ) with no harm for the stored data ?
Thanks in advance for any answer.
Aldo Caruso
I have defined the following domain :
CREATE DOMAIN CURRENCY AS decimal(9,2)
I would like to alter it as the following :
ALTER DOMAIN CURRENCY AS decimal(18,2)
I have many fields in tables that depend on this domain and they
are filled with values.
Will they be restructured in their internal representation ( from
INTEGER to BIGINT in dialect 3 ) with no harm for the stored data ?
Thanks in advance for any answer.
Aldo Caruso