Creating a New Table with a Larger Precision

You can create a new table that is identical to the old one, except with a larger precision value for the IDENTITY column. If the table contains IDENTITY columns that are used for referential integrity, retain the current numbers for the IDENTITY column values.

  1. Use create table entering a larger precision value for the IDENTITY column.
  2. Use insert into to copy the data from the old table into to the new one.