Altering the attributes of an identity column

You can change the attributes of an identity column by using the ALTER TABLE statement.

Procedure

To change the attributes of an identity column:

  1. Issue an ALTER TABLE statement.
  2. Specify the ALTER COLUMN option.
    This clause changes all of the attributes of an identity column except the data type. However, if the ALTER TABLE statement is rolled back, a gap in the sequence of identity column values can occur because of unassigned cache values.

What to do next

Changing the data type of an identity column, like changing some other data types, requires that you drop and then re-create the table.