Here is what sql manager does to alter the identify of a column

Here is what sql manager does to alter the identify of a column