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?

  • When using ALTER-statements the table will not be re-created.

    You will however receive an error when the ALTER-statement will not work.

    For instance: if the data already in that column won't fit the new precision.

    "Walking on water and developing software from a specification are easy if both are frozen." -- Edward V. Berard, "Life-Cycle Approaches"