Home Forums SQL Server 2008 SQL Server 2008 - General Alter numeric(12,6) to numeric(19,4) - is it metadata only or is it recreate table? RE: Alter numeric(12,6) to numeric(19,4) - is it metadata only or is it recreate table?
Lynn Pettis
SSC Guru
Points: 442467
More actions
March 18, 2013 at 8:15 am
#1598057
No, you are changing the precision of the values and could lose data as you are going from 6 decimals places to 4 decimal places.