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.