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?
ScottPletcher
SSC Guru
Points: 100949
More actions
March 18, 2013 at 10:28 am
#1598108
Could you go to NUMERIC(19,6)? That should work fine, and I think it will be just a metadata change.
SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.