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
Can we increase the identity column incremental value
Moderator: NorbertKrupa
-
- Newbie
- Posts: 1
- Joined: Sat Jul 11, 2015 7:13 am
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Can we increase the identity column incremental value
See my answer on StackOverflow.
Checkout vertica.tips for more Vertica resources.