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?
salliven
SSCrazy
Points: 2644
More actions
March 20, 2013 at 1:52 am
#1598755
ALTER TABLE dbo.tablenameALTER COLUMN column_name decimal(19, 6)
ALTER TABLE dbo.tablename
ALTER COLUMN column_name decimal(19, 6)
And how to check the table re-creation?