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?

  • Hi!

    1.) Management Studio => Tools => Options => Designers => "Click the Prevent saving changes..." (Checkbox is on)

    2.) Search your table on the management studio => Right click => Design

    3.) Change column definition (without save)

    4.) Table Designer menu => Generate Change Script. If you get error, then process is use table re-creation. If you get the code, then your change is not use table re-create.