Sql Server identity

identity
To change identity first drop identity column and then add new identity column like
this example

drop identity column

alter table tb_name
drop column col_name

add identity column

alter table tb_name
add columnname int identity(100,1)