CREATE TABLE t1(x IDENTITY(1) ,y INT) Is there a way to change the identity column incremental value from 1 to say 10000. I create the above table now I increment the identity column x IDENTITY(1) to x IDENTITY(10000) I tried below sql but it does not work alter table t1 alter column x SET DATA TYPE...