Modify the Maximum Value of the IDENTITY Column

Alter the maximum value of any IDENTITY column with a modify operation in the alter table command.

alter table my_titles
modify title_id, numeric (10,0)

This operation performs a data copy on a table and rebuilds all the table indexes.