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?

  • ALTER TABLE dbo.tablename

    ALTER COLUMN column_name decimal(19, 6)

    And how to check the table re-creation?