Can we increase the identity column incremental value
Posted: Fri Oct 02, 2015 1:28 am
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 IDENTITY ( 10000 );
Can anyone help
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 IDENTITY ( 10000 );
Can anyone help